Forum Discussion

mhani's avatar
mhani
Frequent Visitor
2 years ago

Get Datasources Power BI Rest API

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

Need Help
Tips and Tricks

2 Replies

  • mhani's avatar
    mhani
    Frequent Visitor
    2 years ago

    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.

     

    BR

    Michael