Importing data from PowerBI to json

[petersenpedro]

Hi guys, 

Is there any way that I can turn a power bi dashboard or dataset into a json(or csv) string? I need something to make a request to my dashboard and get that information.  I'm trying to use python and APIs but I'm stuck. Can you guys help me?

[Anonymous · Accepted solution]

Hi @petersenpedro,

I'd like to suggest you take a look at the export file api to export correspond records:

Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Regards,

Xiaoxin Sheng

[petersenpedro]

Thanks,

I acctually find a solution with this

https://learn.microsoft.com/pt-br/rest/api/power-bi/datasets/execute-queries