Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

export table to excel

Hi,

 

Im having some issues exporting the tables in my dashboard through live connection and that is inside the Power BI Portal(Viewer Mode). I have inside this table different metrics with 3 different timelines which I can drill up or drill down: Fiscal Year, Quarter, Month, Week. When I want to export the table to excel , Power BI automatically exports the whole table with the timelines and when opening the excel file I see many rows with the "weeks" of every month so I have a huge table and also the metrics that where originally showned as rows in my power bi table, in the excel they are showned as columns...

this is how I want the table:

Is there a way to just export the until the month level for example evading the data from the week Level hierarchy?

 

Thanks!

 

 

power bi
  • RobThrive's avatar
    RobThrive
    5 years ago

    That is exactly how it works. Gives the user power to do things their own way with the data. 

    All you need to do is just create a pivot table in Excel now, and it'll match your desired outcome.

1 Reply

  • RobThrive's avatar
    RobThrive
    Resolver I
    5 years ago

    That is exactly how it works. Gives the user power to do things their own way with the data. 

    All you need to do is just create a pivot table in Excel now, and it'll match your desired outcome.