Paginated Report Headers being Changed by Subscription

[aflintdepm]

I have a paginated report that I am subscribed to as a CSV.  When I receive the CSV, the original file name is prepended to every column header in the file.  This is a problem because I need the column headers to be compatible with uploading into another system and this is forcing me to do a Replace across all headers every time I get a new version.

Is this normal behavior or is this something that I can change?

Thank you for your help.

[Anonymous]

Hi,@aflintdepm .
Has your problem been solved?
If you have found suitable solutions, please share them as it will help more users with similar problems.
Or you can mark the valid suggestions provided by other users as solutions.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello,@GilbertQ ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hi,@aflintdepm .I am glad to help you.

Hello, according to your description, you have a situation where the column headings of the data within the subscription file are changed when you create a paged report

I tried to reproduce your issue
The test results are as follows:
In my testing, the individual column names in the subscription csv file seem to be used to describe the current column.
As a result of exporting to a csv file. Many visual objects can only be described by the way the specific data is displayed, so the column name becomes very important, it should clearly depict with the user what the column specifically refers to, you can see that for the original display of the data in the paging report in the bar chart, in excel is converted to the corresponding bar chart attribute description, adding a very large number of character modifiers
In some subscription settings, the file name may be automatically added to the column name to make it easier to identify and manage different versions of the file. This setting is generally used to ensure uniqueness and traceability of files
Adding prefixes can be a real headache in some cases, but I think it's a feature of power BI subscriptions that when converting to a single piece of data, it's important to add enough field modifiers to try to make it as easy as possible for the user to interpret the data.
I didn't find any related settings for the scv file export format in the official documentation.
I think it's feasible for @GilbertQ  to make suggestions, you could try the suggests.
URL:
Dynamically set column names in data flows - Azure Data Factory | Microsoft Learn

Here is my test:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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

[GilbertQ]

Hi @aflintdepm 

As far as I am away, this is bad design in the service. You can create or vote for the idea here. https://aka.ms/FabricIdeas 

Another option might be to use power automate so that you can change the column headers before you then upload it to your new system.