https://community.fabric.microsoft.com/t5/Developer/Export-Power-BI-report-data-to-CSV-using-REST-API/m-p/3879789#M52079 <P>Hi Power BI Community,</P><P>&nbsp;</P><P>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.</P><P>List of questions:</P><UL><LI>Should I use App owns data or User owns data.</LI><LI>Service principal or Master, or any other method?</LI><LI>Authentication method?</LI><LI>How to generate access token?</LI><LI>Does it involve user sign in?</LI><LI>What additional settings I need to do on Azure AD?</LI><LI>Settings required on Power BI?</LI><LI>Any other information which you can provide, which I have not covered.</LI></UL><P>Thanks,</P> Tue, 30 Apr 2024 14:08:37 GMT Anonymous 2024-04-30T14:08:37Z https://community.fabric.microsoft.com/t5/Developer/Export-Power-BI-report-data-to-CSV-using-REST-API/m-p/3879789#M52079 <P>Hi Power BI Community,</P><P>&nbsp;</P><P>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.</P><P>List of questions:</P><UL><LI>Should I use App owns data or User owns data.</LI><LI>Service principal or Master, or any other method?</LI><LI>Authentication method?</LI><LI>How to generate access token?</LI><LI>Does it involve user sign in?</LI><LI>What additional settings I need to do on Azure AD?</LI><LI>Settings required on Power BI?</LI><LI>Any other information which you can provide, which I have not covered.</LI></UL><P>Thanks,</P> Tue, 30 Apr 2024 14:08:37 GMT https://community.fabric.microsoft.com/t5/Developer/Export-Power-BI-report-data-to-CSV-using-REST-API/m-p/3879789#M52079 Anonymous 2024-04-30T14:08:37Z https://community.fabric.microsoft.com/t5/Developer/Export-Power-BI-report-data-to-CSV-using-REST-API/m-p/3880609#M52084 <UL> <LI>Should I use App owns data or User owns data. - That's for the Power BI App owner to decide, not you.</LI> <LI>Service principal or Master, or any other method? - Service Principal or AD user</LI> <LI>Authentication method? - Entra ID preferred/OAUTH2</LI> <LI>How to generate access token? - described in the documentation</LI> <LI>Does it involve user sign in? - not if you use an app registration</LI> <LI>What additional settings I need to do on Azure AD? - make sure the app scope includes Dataset.Read.All</LI> <LI>Settings required on Power BI? - n/a</LI> <LI>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.</LI> </UL> Tue, 30 Apr 2024 20:51:03 GMT https://community.fabric.microsoft.com/t5/Developer/Export-Power-BI-report-data-to-CSV-using-REST-API/m-p/3880609#M52084 lbendlin 2024-04-30T20:51:03Z