This post is also available in: Deutsch

In Power BI, I repeatedly encounter the situation that it does not work to export the underlying data. The option is simply not available. In general, this can have several reasons. In the following article we will take a look at the possible reasons for this.

1. Disabling in Power BI report

The author of a report can limit the export for the specific report. For this purpose, it is possible to select in the options in Power BI Desktop whether users are allowed to export summarized data, the underlying data or no data at all:

Selection whether summarized or underlying data may be exported

2. At least build permission

This post is also available in: Deutsch

Last Friday, Microsoft released the latest Power BI update a little earlier than usual. The highlight from my point of view is the Power Automate Visual ( previously Microsoft Flow), which works with the now released April 2021 version of Power BI

What is Power Automate?

With Microsoft Power Automate it is possible to combine tasks and workflows with different applications in order to automate them. Over 300 services are now supported, for example Dropbox, Outlook, Power BI, Sharepoint, Twitter, SalesForce, etc.

Application areas can be simple notifications, but also very complex and highly automated workflows.
A few examples could be:

  • When a new record is added to a SQL Server table, push it to a Power BI Live Dataset
  • If I got linked on

This post is also available in: Deutsch

Measures are the best way to calculate your key figures in Power BI. In a matrix, however, these can normally only be displayed as values and not at row or column level. However, sometimes you need them exactly at the row level.

Display contribution margin calculation at row level

An example I came across recently was the presentation of a contribution margin calculation. I already apologize if the English terms are not translated correctly, my original calculation was in German ? . The individual items should be displayed below each other at row level. The default view, when displaying only the Measures, is horizontally aligned:

Standard display of measures in matrix in Power BI

This post is also available in: Deutsch

I recently received a tip from a colleague at work, which was also something I hadn’t seen before. More precisely, it was about integrating a Power BI report with all reporting options into a OneNote page.

For this purpose, I use the report with the manual fonts as an example. The report has to be shared on Power BI Services (powerbi.com) via Share –> Embed report –> Publish to web (public):

Report can be shared via Publish to web.
Report can be shared via Publish to web.

Warning: When sharing via “Publish to