export table to excel

Anonymous — Fri, 04 Dec 2020 13:31:05 GMT

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!

Re: export table to excel

RobThrive — Mon, 07 Dec 2020 16:50:43 GMT

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.

topic Re: export table to excel in Report Server

export table to excel

Re: export table to excel