Forum Discussion

DushyantK's avatar
DushyantK
Microsoft Employee
6 years ago
Solved

Export Power BI Report Data to Excel Programmatically

Using Power BI Export Data API  to export the data for the Power BI Report Data including all the Visuals from the Power BI Service to Excel Files but there is an issue if the column values contains ...
Interesting Links
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI DushyantK ,

    As document mention, export data api can only export data to csv format.(Comma Separated Values) I don't think it is possible to do custom on that api to transform exported data format.
    You can consider to use excel to open it, they will analytic by and display on worksheet.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI DushyantK ,

As document mention, export data api can only export data to csv format.(Comma Separated Values) I don't think it is possible to do custom on that api to transform exported data format.
You can consider to use excel to open it, they will analytic by and display on worksheet.

Regards,

Xiaoxin Sheng

  • simontaylor's avatar
    simontaylor
    Microsoft Employee
    4 years ago

    Can you please share some ways to export power bi dataset/datflow into DB? I am still looking for a good way to do it. I prefer to call rest API via ADF for now.