Forum Discussion

Sabarikarthy's avatar
Sabarikarthy
Frequent Visitor
2 years ago

Powerbi rest api

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 a...
General Comment
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    Sabarikarthy
    Frequent Visitor
    2 years ago

    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.