topic Re: Issue in extracting CSV from Paginated report using Power Automate in Report Server

Issue in extracting CSV from Paginated report using Power Automate

Hrishikesh555 — Wed, 08 May 2024 18:28:00 GMT

While fetching tabular data from paginated report to shared folder in csv format using power automate, it is appending table name infront of all field names.

example - if table name is 'tab a' and column names are 'cust name', 'cust address', etc -

* Currently CSV output given as - 'tab_a_cust_name', 'tab_a_cust_address',

* Expected Column names in CSV output- 'cust name', 'cust address', etc.

where is this problem occuring? in paginated report or in power automate workflow? (I believe this has to do with Paginated Report), and how can this be fixed?

Re: Issue in extracting CSV from Paginated report using Power Automate

Anonymous — Thu, 09 May 2024 02:40:42 GMT

Hi Hrishikesh555 ,

Please confirm your settings in Power Automate, you could set the export file name:

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Issue in extracting CSV from Paginated report using Power Automate

Hrishikesh555 — Thu, 09 May 2024 11:19:23 GMT

Hi Anonymous , Yes, I am able to keep the export file name as per my requirement and in CSV format, below provided screenshot for same. However, I'm facing issue with the generated column names in csv file which is different from paginated report. In csv the column names are appended with table name too. I've given example in my main post. It will be really great if you could help in resolving this query.