Forum Discussion
Analyze dataset in excel
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)?
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)
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.
2 Replies
- lbendlin
Super User
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>".
v-xiaotangCommunity Support
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)
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.
