Power BI REST API - GetDatasources

(0) Share

Report

Posted on by ML222

Hi,

I am wanting to build out the Get Datasources Power BI REST API which looks like this:

GET https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/datasources

I am trying to figure out how to pass through all of our Dataset Ids to compile a full JSON on the sources.

I have setup a GetDatasets flow to retrieve all the tenant's datasets, then Parse as a JSON and compose:

It works up to this point. However, I then want to extract all the Dataset id's into an array which can be used to pass through a 'For Each' loop and combined into a single output. I'm getting stuck at this point. I have tried following a few guides on converting a JSON object to an array following this type of setup:

When I run this, I get the following error on the For Each loop:

The outputs on the last "Parse Json" (which is being used as dynamic content) looks as expected and is full of data.

Any ideas please?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report
However, I then want to extract all the Dataset id's into an array which can be used to pass through a 'For Each' loop and combined into a single output.

That's pretty much what you are getting as the output of the API call. You can feed that directly to your loop.

Was this reply helpful? Yes No
ML222 17 on at

Like (0)

Report

I still get that same error saying it needs to be a valid array when I take it directly from the API call.

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

Inspect the raw API output. Could be [value] is empty?

Does your output look anything like this? Datasets - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Also note that your API call only goes after the "My Workspace" datasets. Maybe you wanted to use the other call?

Was this reply helpful? Yes No
ML222 17 on at

Like (0)

Report

Sorry, I am not sure what you mean. Do these help?

Was this reply helpful? Yes No
Verified answer

ML222 17 on at

Like (0)

Report

@lbendlin Thanks for the help.
The GetDatasourcesAsAdmin wasn't working so I tried some of the other GetDatasources to no avail, which is why I was on the My Workspace version of the api.

However, the issue was with the value. I couldn't figure out why since the payload from the Parse JSON did not have any null. The problem was the code that the dynamic content wrote for the value. When using dynamic content it wrote:

I needed to remove that second ['body'] - so manually write in :

Now it ran correctly and looped in all the dataset IDs. (And on the Admin API)

Took 20min to run for 600+ Datasets FYI. I expected +-5mins as it was supposed to be 0.5sec per request as per the documentation, but I guess some throttling happened.

Was this reply helpful? Yes No