⭐ Power BI Interview Questions and Answers (For Freshers)
These questions are designed specially for freshers who are preparing for Power BI interviews. The answers are easy to understand even if you have just started learning Power BI.
1. What is Power BI?
Power BI is a business analytics tool by Microsoft that helps us create charts, reports, and dashboards from different data sources.
2. Why do we use Power BI?
We use Power BI to understand data easily and make better business decisions using visuals and dashboards.
3. What are the main parts of Power BI?
- Power BI Desktop
- Power BI Service
- Power BI Mobile App
- Power Query
4. What is Power BI Desktop?
Power BI Desktop is a software where we design reports and data models.
5. What is Power BI Service?
Power BI Service is a cloud platform where we share reports and dashboards online.
6. What is Power Query?
Power Query is used to clean and prepare data before making visuals.
7. What is DAX?
DAX stands for Data Analysis Expressions. It is used to create custom formulas in Power BI.
8. What is a Measure in Power BI?
A measure performs calculations on data and updates automatically based on filters used in the report.
9. What is a Calculated Column?
A calculated column creates a new column in the data table using a DAX formula.
10. What is a Dashboard?
A dashboard is a single page that shows visuals from multiple reports for quick analysis.
11. What is Data Modeling?
Data modeling is creating relationships between tables to make analysis easier.
12. What is a Relationship between tables?
A relationship connects two tables using a common column (key).
13. What is a Fact Table?
A fact table stores numbers like sales, quantity, or profit.
14. What is a Dimension Table?
A dimension table stores descriptive data like product name, date, region, etc.
15. What is a Star Schema?
Star Schema is a model where one fact table connects to many dimension tables.
16. What is a Slicer?
A slicer is a visual filter that allows users to filter data easily on the report.
17. What is a Filter?
A filter is used to show only selected data based on conditions.
18. What is a Visual in Power BI?
A visual is a chart or graph used to show data in a meaningful way.
19. What is Row Level Security (RLS)?
RLS is used to show different data to different users based on rules.
20. What is a KPI Visual?
A KPI visual shows the performance of a value compared to a target.
21. What is a Report in Power BI?
A report is a collection of visuals across one or more pages.
22. What is DirectQuery?
DirectQuery allows Power BI to read data directly from the source without importing it.
23. What is Import Mode?
Import Mode loads data into Power BI memory for faster performance.
24. Can Power BI connect to Excel?
Yes, Power BI can easily import data from Excel files.
25. Can Power BI refresh data automatically?
Yes, we can schedule automatic data refresh in Power BI Service.
26. What is a Data Source?
A data source is the place where data comes from, like Excel, SQL, or CSV.
27. What is Publish in Power BI?
Publish uploads the report from Power BI Desktop to Power BI Service.
28. What is a Tooltip?
Tooltip displays additional details when we hover over a visual.
29. What is a Page in a Power BI Report?
A page is like a sheet inside a report where we place visuals.
30. Can we share Power BI dashboards?
Yes, dashboards can be shared with other users through Power BI Service.