Forum Discussion

pey's avatar
pey
Frequent Visitor
4 years ago
Solved

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 form...
t
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    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.

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

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.