Power BI Interview Questions and Answers
Ques 16. How do you create a hierarchy in Power BI?
To create a hierarchy in Power BI, you can drag and drop related fields onto each other in the Fields pane. For example, you can create a date hierarchy by dragging the Year, Quarter, and Month fields onto the axis in a visual.
Ques 17. What is the role of Power BI Dataflows?
Power BI Dataflows allow users to extract, transform, and load (ETL) data into a Power BI dataset. It provides a way to centrally manage and reuse data preparation steps across multiple reports and dashboards.
Ques 18. How can you implement time intelligence in Power BI?
Time intelligence in Power BI involves using DAX functions to analyze and compare data over time. Functions like TOTALYTD, SAMEPERIODLASTYEAR, and DATESBETWEEN are commonly used for time-based calculations.
Ques 19. What is the purpose of the 'Card' visual in Power BI?
The 'Card' visual in Power BI is used to display a single, key data point. It is often used to show a summary or a key performance indicator (KPI) in a concise and easily readable format.
Ques 20. How can you handle errors in Power Query?
In Power Query, errors can be handled using the 'try...otherwise' construct. This allows you to specify alternate values or actions when an error occurs during data transformation.
Most helpful rated by users: