This article describes how to quickly publish tables or charts from Excel to portal and how to analyse data in Excel spreadsheet.

We need a Power BI Publisher for Excel. You can download this Excel add-in from here. After short installation you will see this ribbon:

From Excel to

For publishing from Excel to, just click on Pin. Select, where to pin, and confirm.

From this moment the table or chart is published on But, unfortunately, it is just a “dead” image – without any connection to original data.

From to Excel

The other direction is more interesting. You can connect from Excel to data on and analyze them by common Pivot table

Click on Connect to data and select, what do you want to connect to.

Then it works as any Pivot Table with external data.

Be careful about one detail. The data you are analyzing need at least one measure (explicit measure in Power Pivot terminology). This can be added in two ways. You can create it in Power Pivot before uploading to

or you can create it in Power BI Designer (it can not be done in portal).

nebo v Power Bi Desktopu. Varování – přímo na portále to nejde, je třeba pracovat opravdu v Desktopu.

Leave a Reply

Your email address will not be published.


clear formPost comment