Power BI

If there are 4 consecutive data set refresh failures, the refresh schedule will be automatically disabled.

Individual filters and slicers cannot be pinned to a dashboard. This is because dashboards are designed to be an “at-a-glance” perspective. Reports are built to be filtered and interactive. Custom visuals, ribbon charts, and images can be pinned from a report page. 

By default, notifications are available in the notification center. You also have the option of sending notifications via email. A dashboard, Microsoft Teams channel, and a report are not available as the locations of alerts. 

A certified dataset can be configured to be discoverable for users without access to request permissions to access. A promoted dataset can be configured to be discoverable for users without access to request permissions to access. RLS is not required on a dataset to become discoverable. Premium (capacity or shared) is not required to make a dataset discoverable. 

Many-to-many cardinality in Power BI should be avoided due to ambiguity, resulting from the presence of non-unique values. One-to-one cardinality in Power BI should be avoided and, if present, should be eliminated by combining the related tables. However, this type does not introduce ambiguity. One-to-many and many-to-one cardinality are two common cardinality types, used for the relationships between a fact and dimension tables. 

Disabling Auto Date/Time for new files from the Current File options will disable all Auto Date/Time tables in this dataset. Enabling Mark as date table for the Calendar table will also disable the auto datetime tables in the dataset. Disabling the Global option Auto Date/Time for new files means that new files will no longer have Auto Date/Time enabled, but the file containing the current dataset will still have it enabled until it is disabled. Changing the data category will not impact the auto date table feature. 

Implicit Measures: Automatically created, limited customization, context-dependent, not reusable.

Explicit Measures: Manually created using DAX, highly customizable, reusable across multiple visuals, clearly defined.

Implicit measures can select from one of nine aggregations when placed in the Values well of a visual. Both Implicit and Explicit measures can be used as a Drillthrough field, to create quick measures, and with Field Parameters. 

A column that has a lot of repeated values and a low number of distinct values will have a low cardinality. Reducing the number of distinct values reduces cardinality. Replacing nulls does not change the number of distinct values. A static prefix or suffix does not change cardinality. 

DAX Studio, once connected to the data model, can be used to clear the data engine cache. The Clear Cache function can be invoked from DAX Studio, once you connect it to the data model. The Refresh Metadata function can be invoked from DAX Studio to update the metadata of the currently selected model. Adding a blank page to the .pbix file and selecting it is the first step in clearing the visual cache, not the data engine cache. 

To eliminate the impact of visual caching during a performance evaluation when using Performance Analyzer to evaluate the visuals, you must first add a blank page to the report, select that page, and then reopen the PBIX file. Connecting DAX Studio to the data model is the first step to clear the data engine cache. Recording should not be started until both the visual cache and the data engine cache are cleared. 

The CALENDARAUTO function generates a range of dates based on the earliest and latest date within the dataset. The CALENDAR function generates a range of dates, but it requires providing the start and end date. The DATE function returns the specified date in the datetime format. The DATEDIFF function returns an interval between two dates. 

The CALCULATE function provides the result of the calculation with the ability to override the context. The IGNORE function modifies the behavior of the SUMMARIZECOLUMNS function by omitting specific expressions from the BLANK/NULL evaluation. The FILTER function returns a table that represents a subset of another table or expression. The SUMX function returns the sum of an expression evaluated for each row in a table. 

The slicer visualization can be used to filter the other visuals on the page. You can enable a search box in a slicer where users can search for values to filter. A funnel visualization is a chart that that has sequential connected stages, where items flow sequentially from one stage to the next. A matrix visualization displays data in two or more dimensions and cross-highlights with other visuals on the same report page. A scatter chart visualization is a chart with one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis. The matrix, scatter chart, and funnel do not offer a search box.