Export Power BI report data to CSV using REST API

[TusharMK]

Hi Power BI Community,

I am a RPA Developer, planning to build an automation using UiPath which will download 20-30 reports's summarized data into CSV format using REST API for in house Finance team. I do not have much experince on APIs.

List of questions:

• Should I use App owns data or User owns data.
• Service principal or Master, or any other method?
• Authentication method?
• How to generate access token?
• Does it involve user sign in?
• What additional settings I need to do on Azure AD?
• Settings required on Power BI?
• Any other information which you can provide, which I have not covered.

Thanks,

[lbendlin · Accepted solution]

• Should I use App owns data or User owns data. - That's for the Power BI App owner to decide, not you.
• Service principal or Master, or any other method? - Service Principal or AD user
• Authentication method? - Entra ID preferred/OAUTH2
• How to generate access token? - described in the documentation
• Does it involve user sign in? - not if you use an app registration
• What additional settings I need to do on Azure AD? - make sure the app scope includes Dataset.Read.All
• Settings required on Power BI? - n/a
• Any other information which you can provide, which I have not covered. - When running DAX queries against the XMLA endpoint make sure to include nulls else your CSV will be all crooked.