Export Power BI report in a JSON format

[Anonymous]

Hi!

Is there a way to export Power BI report in a JSON or similar machine readable format so we can reuse the data elswhere?

[Anonymous]

Hi @Anonymous ,

You can use the R script to convert the data frame into JSON format and export into a JSON file. Refer to the following solution for detailed steps:

Solved: Export data in JSON format - Microsoft Fabric Community

Best Regards,
Adamk Kong

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

[Anonymous]

I guess this would be prefered, but I would need a more detailed explnation, Im not familiar with R.

[NandanHegde]

You can use REST API to extract data from Power BI.

Below blog provides the details :

https://datasharkx.wordpress.com/2023/03/02/overcoming-data-size-row-limitations-of-power-bi-rest-ap...

[NandanHegde]

Hey,

can you clarify what you mean by export report as JSON data?

Do you need to export the data within Power BI dataset in JSOn format or you want to preserve the meta data of the PBIX file in JSON format?

[Anonymous]

@NandanHegde  Not sure what is the best option, but we would like to re-use the "final" data from the dashboard in other internal tools.