Power BI Interview Questions

What are the benefits of using variables in DAX?

Post Views: 48,957 Here are some benefits of using variables in DAX: By declaring and evaluating the variable, a variable can be reused multiple times in the DAX expression so that we can avoid additional queries of the source database. Variables can make DAX expressions more logical to interpret. Variables are only used to their measure or query; they cannot be shared among measures, queries, or cannot be defined at the model level.

Read More

What is DAX?

Post Views: 48,953 DAX (Data Analysis Expressions) is a formula expression language. It can be used in different BI and visualization tools. DAX is also known as function language in which the full code is kept inside a function. DAX works on column values. DAX cannot insert or modify the data. We can create a calculated column and measures with DAX, but we cannot calculate rows using DAX.

Read More

What are the Power BI dataset, Report, and Dashboard?

Post Views: 48,948 Dataset: The source is used to create reports and tiles or visuals. A data model (local to PBIX or XLSX) in an Analysis Services Server Data could be inside of model or a Direct Query connection to a source. Report: An individual Power BI Desktop file (PBIX) containing one or more report pages. It is built for deep, interactive analysis experience for a given dataset (filters, formatting). Each Report is connected to at least one dataset Each…

Read More

What is Power BI Publisher for Excel?

Post Views: 48,937 You can use Power BI publisher for Excel to pivot tables, pin ranges, and charts to Power BI. The user manages the tiles such as remove them, refresh them, in Excel. Pinned items must be removed from the dashboard in the service (removing in Excel only deletes the connection). The Power BI Publisher for Excel is also used to connect from Excel to datasets which are hosted in the Power BI Service. An Excel pivot table is…

Read More

Is Power BI available On-Premises?

Post Views: 48,928 No, Power BI is not available as a private and internal cloud service. But, with Power BI and Power BI Desktop, you can connect to your own on-premises data sources securely. With the On-premises Data Gateway, you can connect live to your on-premises SQL Server Analysis Services and other data sources. Also, You can schedule refresh with a centralized gateway. If a gateway is not available, then you can refresh data from on-premises data sources using the…

Read More

What is Power Map?

Post Views: 48,928 Power Map is an Excel add-in which provides a powerful set of tools to help you in visualize and gain insight into large sets of data that have a geo-coded component. It can produce 3D visualizations by plotting up to a million data points in the form of column, heat, and bubble maps on top of a Bing map. If the data is time-stamped, it can also produce interactive views that display how the data changes over…

Read More

What is Power Query?

Post Views: 48,914 Power query is an ETL tool which is used to shape, clean, and transform data using intuitive interfaces without having to use coding. It helps the user to: Import the data from a wide range of sources from files, big data, databases, and social media data, etc. Join and append the data from multiple data sources. Shape the data as per requirement by adding and removing the data.

Read More