Problem with dynamic column headers and export to csv

[lisannegesch]

Hi all,

I used this tutorial to make dynamic columns: https://www.youtube.com/watch?v=6jeSIRpjv0M&ab_channel=BIElite which is working fine. But I want to export it to csv from to report server and I don't get the format of the visual. I can't download the table in this format, I see the error: this is only available for a table or a matrix. Eventhough it is a matrix. 

Does anyone know how I can make an adjustment so that the users of the dashboard can download the visual in the format in which it is on the report server?

Followup question: now it looks like I can't order the columns in a random order. For example: the order in which I select the slicer. It orders it alphabeticly. Is there a way I can avoid that?

[v-jiewu-msft · Accepted solution]

Hi @lisannegesch ,

Based on my learning, only the summarized data is supported export within Power BI report server.

You can view the following document to learn about report server limitations.

Compare Power BI Report Server and the Power BI service - Power BI | Microsoft Learn

Besides, try to export a report to a csv file on report builder.

Export a paginated report to a CSV file - Microsoft Report Builder & Power BI Report Builder | Micro...

For the random order question, create a calculated column or measure and select sort by column.

You can also view the following link to learn about sort.

Solved: Re: How can I sort the text values in a filter obj... - Microsoft Fabric Community

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.