Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Export Power BI Report Data to Excel Programmatically using Export Data API not working

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: 

Excel.png

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

 

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @DushyantK

 

Please create a support ticket to get help. 

 

Support Ticket.gif

 

Best Regards,

Qiuyun Yu