Get Datasources Power BI Rest API

[mhani]

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

[mhani]

Hi @v-rzhou-msft 

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.

BR

Michael

[v-rzhou-msft]

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.