Power BI Interview Questions

Power BI is a cloud-based business analytics service that enables anyone to visualize and analyze data with greater speed, efficiency, and understanding. It connects users to a broad range of data through easy-to-use dashboards, interactive reports, and compelling visualizations that bring data to life.
Power BI provides all sorts of features to help you get started exploring data in a whole new way. Power BI Pro provides all of the same great features in Power BI, plus additional features like more storage capacity, scheduling data refresh more frequent than daily, live data sources with full interactivity, groups, and more. Learn more about the differences between Power BI Pro and the free Power BI.
Power BI Desktop is a free desktop application you can install right on your own computer. Power BI Desktop works cohesively with the Power BI service by providing advanced data exploration, shaping, modeling, and report creation with highly interactive visualizations. You can save your work to a file, and publish your data and reports right to your Power BI site to share with others.
It is a natural language data quering where we can directly plot charge by simpl typing Questions on data set like: Total sales by year and area It is available only when reports are published to cloud(power bi.com or sharepoint). .
To do basic calculation and data analysis on data in power pivot we use Data Analysis Expression (DAX).It is formula language to compute calculated column and calculated field. Dax works on column values
Dax can not modify or insert data
We can calculate calculated column and measures but we can not calculate rows using dax
Sample DAX formula syntax:
For the measure named Total Sales, calculate (=) the SUM of values in the [SalesAmount ] column in the Sales table.
A- Measure Name
B- equal sign – indicate beginning of formula
C- DAX Function
D- Parenthesis for Sum Function

Power BI does not support email addresses provided by consumer email services or telecommunications providers. Learn more about the Power BI self-service sign-up process.
Power query is a ETL Tool use to shape,clean and transform data using intuitive interfaces without having to use code.
. Import data from wide range of source from files to databases,big data to social media.
. Join and append data from multiple data sources
. shape data as per requirement by removing and adding data.
The main engine behind power pivot is the xVelocity in-memory analytics engine. It can handle large amount of data because it stores data in columnar databases and in memory analytics which results in faster processing of data as it loads all data to RAM memory. For best result use 64 bit operating system as 64 bit can load more data to RAM.
The list of data sources for Power BI is extensive, but it can be grouped into the following:
i) Data from Excel and Power BI Desktop files.
ii) Content packs for services, with ready-made dashboards, reports, and datasets for services such as Salesforce. In addition to establishing a data connection, Power BI provides pre-built dashboards and reports for each of these services.
iii) Connectors to databases and other datasets such as Azure SQL Databaseand SQL Server Analysis Services tabular data.
An effective PPC keyword should be
Power Query—find, edit and load external data
PowerPivot—for data modeling for analysis
Power View—design visually and interactively reports
Power Map—display insights on 3D Map

It is a stand alone application where we can make Power BI reports and than upload it to power bi.com, it does not requires excel.
Visual level filters i) These filters work on only an individual visualization, reducing the amount of data that the visualization can see. Moreover, visual-level filters can filter both data and calculations.
Page level filters
i) These filters work at the report-page level. Different pages in the same report can have different page-level filters.
Report level filters
i) There filters work on the entire report, filtering all pages and visualizations included in the report.
No we cannot have more than one active relationship between two tables in the data model
Data model in Power pivot is made up of tables,columns,datatypes,and table relations. Tippically data tables are constructed to hold data for a Business entity.
Yes. Power BI has native apps for Android phones and tablets, iOS devices, and Windows 10 devices.
Download one of the Power BI mobile apps from its respective store:
. Apple App Store
. Google Play
. Windows Store
Power BI and Power BI Desktop are free. There is a 60-day free trial available for Power BI Pro. After that, Power BI Pro is $9.99/User/Month. Learn more about our pricing Power BI pricing.
While there is not a direct way to discover this, you can view the Azure Active Directory Integrated Applications report for Power BI to see who are active users within your organization. Those active users in the eligibility period, and who are on free licenses, will receive the pop-up notification. For more information, see Find Power BI users that have signed in.
Power BI does not support email addresses provided by consumer email services or telecommunications providers.
Yes, non-profit pricing is available when purchasing directly from Microsoft. You can learn more and sign up through the Microsoft Product Donation site. Government and academic pricing is offered through the MOSP/Direct, EA, and Open licensing programs.Government pricing is also available in syndication. Power BI is not yet available for the US Government Community Cloud (GCC).
Hive provides no additional capabilities to MapReduce. The programs are executed as MapReduce jobs via the interpreter. The Interpreter runs on a client machine which rurns HiveQL queries into MapReduce jobs. Framework submits those jobs onto the cluster.
No, the Power BI service is not available as a private, internal cloud service. However, with Power BI and Power BI Desktop, you can securely connect to your own on-premises data sources. With the On-premises Data Gateway, you can connect live to your on-premises SQL Server Analysis Services server, and other data sources. You can also scheduled refresh with a centralized gateway. If a gateway is not available, you can refresh data from on-premises data sources using the Power BI Gateway - Personal. You can also view on-premises SQL Server mobile reports with the Power BI iOS apps: . SQL Server mobile reports on iPad and iPhone.
Content packs for services are pre-built solutions for popular services as part of the Power BI experience. A subscriber to a supported service can quickly connect to their account from Power BI and see their data through live dashboards and interactive reports that have been pre-built for them. We’ve released content packs for popular services such as Salesforce.com, Marketo, and Adobe Analytics. Read more about connecting to services with content packs.Organizational content packs provide users, BI professionals, and system integrators the tools to build their own content packs to share purpose-built dashboards, reports, and datasets within their organization.
The following resources are available to help get your started:
. Power BI Blog
. Webinars
. Getting started videos on our YouTube Channel
. Get started with Power BI article
. Join our community and ask questions

• Microsoft Edge
• Internet Explorer 11
• Chrome desktop latest version
• Safari Mac latest version
• Firefox desktop latest version
You can purchase Power BI Pro licenses directly or chat with a representative at www.powerbi.com. You can also find a Microsoft Partner to help you with your Power BI implementation.
The Power BI for Office 365 experience has been deprecated.
Like many other Microsoft services and software, Power BI provides an easy way to undo your last command.
• To undo your last action, or last few actions, press CTRL+Z.
Just a Web browser and work email address. Note: Work email addresses ending in .gov and .mil aren’t currently supported.
Users who signed up to Power BI (free) on or after May 3, 2017 are not eligible for the Extended Pro Trial. However, they are eligible for the standard 60-day Pro Trial.
Power BI Desktops use rights do not limit you to one copy of Power BI Desktop for the entire company. Each individual user at the company may install and use one copy on their premises.
Yes we can refresh our reports through a data management gateway(or sharepoint)and Power Bi personal gateway (for power bi.com)
1. Android Mobile
2. iphone and ipad
3. Windows desktop and Windows tablates
4. Windows phones comingsoon
Power BI Desktop is a Windows application (Clinet) running on the local computer. It is more a of client machine which can connect with variety of data sources from your computer to the data in the local computer or the data in the server. Power BI Power BI is a cloud solution. We can use web browser to connect with Power BI. We can perform the same development work using either Power BI OR Power BI Desktop.
- Visualizations
- Datasets
- Reports
- Dashboards
- Tiles
Request a Call Back

Enter your Phone Number

Quick Contact

* Required Field


Get A Free Quote / Need a Help ? Contact Us