How to get data from backend of Power Bi to Uipath studio through api calls?

This question explores the process of extracting data directly from the backend of Power BI and transferring it to UiPath Studio using API calls. It delves into the steps involved in setting up authentication, accessing datasets, retrieving data, and processing it within UiPath Studio. The discussion covers the utilization of the Power BI REST API, including authentication mechanisms, endpoint usage, and data handling techniques. Additionally, it emphasizes the importance of adhering to Microsoft’s guidelines and data privacy regulations while accessing Power BI backend data.

Hi ArjunKrishna,

Basically you want to call power Bi data using UiPath api activities.
So, basically in Power Bi there is an option in upper ribbon Get Data.

Click on → Get data–> A dropdown will open–> then select web option–> after that you can enter details of api in req fields create api’s and then in Ui-Path call that api’s with same parameters and done data will be fetched.

For further details please refer to link:
https://support.softools.net/hc/en-gb/articles/360002659237-Power-BI-Connection-via-the-API-Web-Call#:~:text=First%20open%20the%20Power%20BI,to%20make%20the%20data%20call.

I hope this will give you a proper way-out towards your automation process.

Thank you ArjunKrishna :slight_smile:
Please let me know if my help was bit helpful or not.