Analyze dataset in excel

[pey]

Hi All 

I am on power BI Pro (60 days trial) and have published several report to my workspace. However, data is only available in Pivot format. Any change to output them in original dataset format (i.e same format as the source excel workbook)? 

[v-xiaotang · Accepted solution]

Hi @pey 

Clicking Analyze in Excel will give you a new blank Pivot Table connected to the Power BI Service as shown below.

Power BI Analyze in Excel – What You Need to Know

-

Since each visual in the report can be exported as a sheet, you can use the data export function for the visual separately (see below)

Export data

Besides, if you want to export the Data of a Power BI table entirely, see this article

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Analyze in Excel gives you access to the data model.  It is quite a bit more powerful than a single Pivot table.  But you can also use it to recreate the tables from your data model.  An alternative is to run DAX queries like "EVALUATE <table name>".