How can i retrive information from power bi web to my bubble app

Need help
1

Can someone please help me understand how i can retrieve directly from powerbi a report so I can take the data that the report has to my bubble app

2

Power BI doesn’t give raw data directly from a report, but you can pull the dataset behind it.

  1. Go to Power BI Service → open the workspace that has your report.

  2. Find the dataset linked to that report.

  3. Click Settings → API Info or copy the Dataset ID and Group ID from the URL.

  4. In Bubble, open the API Connector plugin.

  5. Add a new API call:

    • Method: GET

    • URL: https://api.powerbi.com/v1.0/myorg/groups/[GroupID]/datasets/[DatasetID]/tables

    • Add Header: Authorization: Bearer [your access token)

  6. Use the returned JSON data in Bubble’s database or repeating groups.

You’ll need to create an Azure app registration to get the access token that Power BI API accepts.

3

sorry that i did not respond the first time you responded to me forum, but as you may see on the picture where exactly is the Dataset linked, as you may see in power bi we only have the report but not the table should i upload the table to power bi web and then get the dataset or do i can get it on the picture you see below?

image
image1896×958 110 KB