Dataverse read permission for a Power BI report

If you use dataverse data in a Power BI report, a reader of the report also needs read permissions on the dataverse table, since this data is loaded live into…

Connect Facebook data with Power BI

Integration of Facebook with Power BI To integrate Facebook data with Power BI, the user must have a Facebook account, the user does not need a special type of account,…

Power BI – Deactivate date hierarchy

The automatic date hierarchy in Power BI can sometimes interfere with the chronological display of data. You can deactivate the hierarchy as follows: Drags the date field into the axis…

Power BI Lookup/VLOOKUP

SUSTAINABILITY in Power BI Apart from the importance of VLOOKUP function, we can use the same function in Power BI. This is the most common question of all Power BI…

Tips for visualization in Power BI

In this collection you will find many tips and tricks for your Power BI reports.

Power BI – move the local Excel file to OneDrive or SharePoint

If you use an Excel file as a source in Power BI, it is usually connected locally. Now you cannot update the source without a gateway. With the following steps…

Show address, zip code and city in PowerBI on a map

If your location is not displayed, it may help to categorize the data as an address.

Replace error or error in PowerBI

To replace any error values in PowerBI, you can use this function by right-clicking in a column: You can then select the value that replaces the error: Further details can…

Compose addresses from street, city and postal code in PowerBI

So that address data from e.g. SharePoint can be displayed on a map in PowerBi, you must compile the data in a new column. Here is an example with the…

Display PowerBI parameters in the report

To display a defined parameter in a report, you must activate loading:

Display multiple selection from SharePoint in PowerBI

We’ll post our own experience soon… Until then, this source will help: https://whitepages.unlimitedviz.com/2018/01/using-power-bi-to-report-on-multi-value-sharepoint-fields/

Time zone problem with SharePoint data in PowerBI report

The easiest way is to add an additional column with the “local time”. First the affected column as time incl. Define and select the time zone and then create the…