Export Power BI report in a JSON format

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.

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?

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-api-for-automated-data-extraction-from-dataset/