export data of a visual into APIs (JSON or XML)

[roozbeh_al]

Hey all,

When you choose to export the data of a visual, you can only export its data to csv file.

Is there anyway I can export the data of this visual in APIs?

[v-henryk-mstf · Accepted solution]

Hi @roozbeh_al ,

According to official documents, there are certain restrictions on exporting.

Generally speaking, only summarized data or underlying data can be exported. But if you want to export through jason, here is a solution: Export data in JSON format

reference document link: Export data from a Power BI visualization - Power BI | Microsoft Docs

If the problem is still not resolved, please provide detailed information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[negi007]

@roozbeh_al  I am not sure if it possible to export data from visual in api format. Normally APIs are system generated output file and can export data or import data as per a fixed time or duration. There is a token mechanism in API which may not be possible while exporting data from visual. Please have a look at below articles for exporting data to apis

https://docs.microsoft.com/en-us/power-bi/developer/embedded/export-to#:~:text=When%20the%20export%2....

https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exporttofile

https://docs.microsoft.com/en-us/power-bi/developer/embedded/export-to

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data