Export Power BI Report Data to Excel Programmatically

[DushyantK]

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 "," the table is being unstructured.

Is there an alternative approach/workaround for the same?

Example: 

Is being returned as :

id,Company,yrs_on_list,Revenue
,,2961,30857253566
451,Fortis, Construction,45,2447673845
854,Monogram Foods,45,2324662211
1146,Consumer Cellular,45,2888574796
1350,Parts Town,45,707520122
1627,Access Information Management,45,885227743
2053,Cellular Sales of Knoxville,45,7089003221
21648,Great Lakes Caring,45,1229281823
22630,American Technologies,45,1008168547
22677,PREFERRED FREEZER SERVICES,45,1751587467

[Anonymous · Accepted solution]

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]

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.