Forum Discussion
Problem with dynamic column headers and export to csv
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?
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.
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.
1 Reply
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.
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.