dataset name Prefix to columns in a csv file in paginated report subscription in PowerBI service

[Anonymous]

Hello Community,

I built a pagnited report in PowerBI service web potal, which I output as csv through subscription, but I see the datasets name is prefix to the column name  in the file which is not a desirable for viewer consumption.

I  do appreciate any recommendation on how to remove the dataset prefix from the columns. See a snippnet below.

Thank you 

Samson

[Anonymous]

I was able to removed the prefix by opening rdl file with notepad , since it built of XML data structure . I removed the prefix, save and uploaded back into the server

[rpatkar · Accepted solution]

Cool, nice to see you find a workaround here. Please check out Render data in a Power BI paginated report - Power BI | Microsoft Learn - "The DataElementName property controls the name of the data element. In CSV, this controls the name of the CSV column header." DataElementName is a property on the column header that you can set by opening the RDL file in Power BI Report Builder.