Technical Interview Questions
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; … Read more
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 … Read more
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 … Read more
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 … Read more
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. Implementing data security … Read more