topic Re: Get Datasources Power BI Rest API in Developer

Get Datasources Power BI Rest API

mhani — Wed, 20 Sep 2023 12:24:42 GMT

Hi,

I am struggling to figure out if it is possible to get knowledge about the storage type of a data source. I see it is possible with the Get Datasets API (ContentProviderType) but I cannot find it per data source instead of per dataset.

Did any of you succeed in that? please let me know

Michael

Re: Get Datasources Power BI Rest API

Anonymous — Fri, 22 Sep 2023 03:06:13 GMT

Hi @mhani ,

I think you can try Power BI REST API as below.

For reference:

Datasets - Get Datasources

Datasets - Get Datasources In Group

Best Regards,
Rico Zhou

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

Re: Get Datasources Power BI Rest API

mhani — Mon, 25 Sep 2023 07:31:36 GMT

Hi @Anonymous

Thanks for replying my post.

I have been looking into these API's although I cannot find a way to get the storage type for each datasource in these.

As I see it, I will get the storage mode for the dataset in whole, and not the datasource.

So what I will get is:

Dataset id 1 (Composite model)

Datasource1 - SQL

Datasource2 - Sharepoint

Datasource3 - Excel

But what I want to get is:

Dataset id 1 (Composite model)

Datasource1 - SQL (Direct Query)

Datasource2 - Sharepoint (Import)

Datasource3 - Excel (Import)

So I want to get the datasource and then the type from the api. And not the storage mode for the complete dataset.

Michael