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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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>".