Keventer Interview Questions and Answers

To share a Power BI report with an external user, we can use the Publish to Web feature or share it via email.

• Use the Publish to Web feature to generate an embed code that can be shared with external users

• Ensure that the report contains only non-sensitive data before using the Publish to Web feature

• Alternatively, share the report via email by granting access to the external user's email address

• The external user must have a Power BI account to view the report

There are four types of connections available in Power BI.

• Power BI Desktop Connection

• Power BI Service Connection

• Power BI Mobile Connection

• Power BI Gateway Connection

There are three types of filters available in Power BI.

• Visual level filters

• Page level filters

• Report level filters

Power Pivot is available in Power BI Desktop and Power BI Service.

• Power Pivot is a data modeling tool in Excel that allows you to create relationships between tables and perform complex calculations.

• In Power BI Desktop, you can access Power Pivot by going to the 'Data' tab and selecting 'Manage Relationships'.

• In Power BI Service, you can access Power Pivot by going to the 'Settings' menu and selecting 'Data Sources'.

• Power Pivot is used to create more complex data models and c...read more

Dependent slicer in Power BI allows filtering of data based on selection in another slicer.

• Create two slicers, one for the main category and another for the sub-category.

• Add the main category slicer to the report page and select the sub-category slicer.

• Go to the Format pane and select the 'Edit interactions' option.

• Choose the 'Filter' option for the sub-category slicer.

• Now, when a main category is selected, the sub-category slicer will only show options related to that catego...read more

Direct connection is a static connection to a data source, while live connection is a dynamic connection that updates in real-time.

• Direct connection requires data to be imported into the analysis tool, while live connection accesses data directly from the source.

• Live connection allows for real-time updates and analysis, while direct connection requires manual refreshing.

• Direct connection is useful for small datasets or when data is not frequently updated, while live connectio...read more

Incremental refresh is a feature in Power BI that allows you to refresh only a portion of your data instead of the entire dataset.

• Incremental refresh is useful for large datasets that take a long time to refresh.

• It allows you to refresh only the new or updated data since the last refresh.

• You can set up incremental refresh by defining a range of values for a column that represents the refresh window.

• For example, you can set up incremental refresh to only refresh data from the ...read more