Forum Discussion
export data of a visual into APIs (JSON or XML)
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?
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.
2 Replies
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/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
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.
