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!