Data profiling tools

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 …

PBIT and PBIDS files

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

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.

Power BI user roles

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 …

Power BI alerts

When you create a dashboard within the Power BI service, you may want to be notified if the data reaches a certain predefined value. For this purpose we use Power BI Alerts, and one can only be created for Gauge, Card and KPI visualizations. In the following text you will find out how to use this Power BI service feature.