Whether we use Excel BI or Power BI data model, we can create a hierarchy of employees manually or with the help of some DAX functions. In this text you will learn how to use two such functions: PATH and PATHITEM. With their help, it is possible to create calculated columns that show the hierarchical level of each of the employees within the company.
When importing tables from data sources there is a possibility of error or import of empty values. Also, in order to optimize the model, there is often a need to see the structure of the data according to the columns. One way to achieve this is to filter the table and view the filter values. It can serve! However, Power Query has built-in tools that allow us to easily view data statistics …
Power BI Desktop reports are stored in PBIX files that contain connections, datasets, transformations, visualizations, and other report elements. If you want to save reports without data, you will use the option of creating a template, by saving as a PBIT file. If you want to save only the link to the data source you will create a PBIDS file.
Power BI apps are a combination of datasets, reports and dashboards that we want to integrate into a whole and thus share them with team members or other people in the organization. For example, if the sales department hires a new employee to have access to sales reports and dashboards, it is enough to install the Sales application. An administrator can even set such an application to be installed automatically.
In one of the previous “recipes” you could find out what Power BI Workspace is. In short, it is a collection of datasets, reports and dashboards that we want to manage within the Power BI tenant of a company. When working with the service, there is a need for different users to have different levels of access to the content. In this text you will learn more about user roles …