Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
pdroge84
Regular Visitor

REST API help

Hi all,

 

We have a custom application which fetches data from several other systems.

Each system has it's own API endpoint. Now we have it working that for each API Endpoint you can create a table within Power BI. However you have to setup each endpoint seperate.

 

Now we're investigating if it is possible to have to following situation:

 

A endpoint returns a table with all available endpoints:

NameEndpoint
Endpoint Ahttps://host.nl/api/v1/endpointA
Endpoint Bhttps://host.nl/api/v1/endpointB
Endpoint Chttps://host.nl/api/v1/endpointC
Endpoint D

https://host.nl/api/v1/endpointD 

 

PowerBI will call this API endpoint and rerieves this table.

After this, we want to loop through this result and create a table with each endpoint.

 

It is posisble that that this table could be extended with more endpoints which should result into create more extra tables.

 

Is this possible and if so how/could anyone point me into the right direction?

 

Note: All data is returned as JSON.

 

Kind regards,

Pdroge

1 REPLY 1
michaelx2
Microsoft Employee
Microsoft Employee

Hello @pdroge84,

At the moment, Power BI REST API does not support getting row data in dataset. You can check and vote up this idea REST API access to READ datasets to improve Power BI on this feature. 

Since that, you may create the table which stores the endpoints configuration in you custom application as a workaround.

 

Best Regards

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.