POWERBI Interview Questions

Ques 1. What is POWERBI ?

Ans. PowerBI is a software that allows you to connect to different data sources and visualize your data and share insights across your organization

Ques 2. What is POWERBI desktop ?

Ans. It is a free desktop application for personal computers,primarily for designing,generating and publishing reports to the cloud.

Ques 3. Features of PowerBI?

Ans. Some of the Important Features of PowerBI : 1.It allows users to transform data into visuals and share those visuals with colleagues. 2.It allows users to explore and analyze data from all sources . 3.Once an output is generated, users can display the same in multiple devices that are compatible with the Power BI application.

Ques 4. Is Power BI free to use?

Ans. YES,users can use Power BI for free. However, the best of Power BI can be availed with the Power BI Pro subscription account.

Ques 5. What are the versions of Power BI?

Ans. Different Versions of PowerBI are 1.Power BI Desktop -The on-premise version for Windows 10 2.Power BI Service -For publishing to the cloud 3.Mobile Power BI -For mobile users

Ques 6. What are the major components of Power BI?

Ans. Major components of PowerBI are 1.Power Pivot - It extract and cleans data and loads on to Power Query 2.Power Query - It operates on the loaded data 3.Power Q&A - Makes it possible for users to interact with reports using simple English language 4.Power View - It lets users create interactive charts, graphs, maps, and other visuals 5.Power Map - It enables the processing of accurate geographic locations in datasets

Ques 7. What are Building Blocks in Power BI?

Ans. 1.Visualizations -Visualization is a visual representation of your data. 2.Datasets -Dataset is a collection of data that Power BI uses to create its visualizations. 3.Reports -Report is a collection of visualizations that appear together on one or morethan one pages. 4.Dashboards -Dashboard is single layer presentation of multiple visualizations. 5.Tiles -Tile is a single visualization in a report or on a dashboard

Ques 8. Work of GETDATA?

Ans. It is used to import data from various sources.

Ques 9. What data sources can Power BI connect to?

Ans. Power BI can connect to different data sources like : 1.Files - Excel, Text/CSV ,XML,JSON etc 2. Databases -SQL SERVER database,MYSQL database,Access database, SAP database etc 3.Online services - Sharepoint online list,facebook,gethub etc 4.Azure -Azure SQL Database, Azure SQL Data warehouse etc 5.Others -Hadoop file,Spark,ODBC

Ques 10. What is Power Query ?

Ans. Power query is a ETL Tool used to shape, clean and transform data .

Post Question Details

Ques. How to open Password Protected File in Power BI ?

Posted On:3/19/2021 8:02:48 PM

Ques. How to change the Mode from Import to Direct Query in Power BI ?

Posted On:3/19/2021 7:53:00 PM

Ques. What is Deployment Pipeline in Power BI ?

Posted On:3/19/2021 7:52:07 PM

Ques. What is Live Streaming Dataset in Power BI ?

Posted On:3/19/2021 7:51:47 PM

Ques. How to freeze the data used in the reports of Power BI , so that it should not get refreshed?

Posted On:3/19/2021 2:04:36 PM

Ques. What is Web URL Conditional Formatting in Power BI ?

Posted On:3/17/2021 7:05:04 PM

Ques. How to change the cluster name in Scatter Charts?

Posted On:3/15/2021 10:01:45 PM

Ques. How to reset the filter selection in a Power BI Report Page?

Posted On:3/15/2021 10:00:42 PM

Ques. What is the difference between Personal Gateway and Enterprise Gateway in Power BI ?

Posted On:3/14/2021 7:56:07 PM

Ques. How to delete a particular row from the datasets of Power BI after loading the data into Power BI?

Posted On:3/14/2021 7:51:23 PM