Powerbi rest api

[Sabarikarthy]

I need a clarification in connecting power bi rest API to power bi desktop.

I am able to retrieve the data via power automate flows and checking I could create a report to visualise.

I have achieved this is power automate by registering an azure ad application and with the help of client secret I am generating a token by which am authenticating rest api.

When I try the same in power bi, not sure what details I need to enter in the API Key section. 

Please help me with the overall flow that I need to follow to get the rest API data to powerbi

[Anonymous]

Hi @Sabarikarthy ,

You can open the Power BI desktop, click on the “Get Data” button and select the “Web” option as shown in the below screenshot:

And here you can enter the URL of API which returns the data you want to fetch.
For specific steps on connecting and authenticating, you can refer to the answers in this thread:
Solved: Connecting Power BI with API - Microsoft Fabric Community


Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sabarikarthy]

Thanks for the response.

Actually I am using the rest API to get the list of workspace. I have my client secret and the bearer token.

While authenticating, not sure what I should enter as an api key.