Forum Discussion
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 "," 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
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
2 Replies
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
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.
