Forum Discussion

Hrishikesh555's avatar
Hrishikesh555
New Member
2 years ago

Issue in extracting CSV from Paginated report using Power Automate

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?

"Power Automate"
"Power BI"
@paginated report
@PowerBI Builder Paginated Report
CSV file

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

    • Hrishikesh555's avatar
      Hrishikesh555
      New Member
      2 years ago

      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.