Power BI Interview Questions | Eklavya Online

Power BI Interview Questions

What are the benefits of using variables in DAX?

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; …

What are the benefits of using variables in DAX? Read More »

What is DAX?

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 …

What is DAX? Read More »

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

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 …

What are the Power BI dataset, Report, and Dashboard? Read More »

How is data security implemented in Power BI?

Power BI applies the row-level security role to models: A DAX expression is used on a table, filtering its rows at the query time. Dynamic security involves the use of USERNAME functions in security role definitions. A table is created in the model which relates users to specific dimensions and a role.

What is Power Map?

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 …

What is Power Map? Read More »

What is query folding in Power Query?

Query folding is when steps defined in Power Query or Query Editor are translated into SQL and executed by the source database rather than the client machine. It is important to processing performance and scalability, given limited resources on the client machine.

What is Power Query?

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 …

What is Power Query? Read More »