Forum Discussion

TexasBI's avatar
TexasBI
Helper II
4 years ago

Find the mode type in a dataset through the API

Hello,

 

I have been able to pull all the datasets as the admin, but I would like to tell what mode they are on (Direct Query, Import, Dual)?? How can I do this through the API?

 

Thank you,

 

Chris

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi TexasBI 

    If you connect to your data source by API, I think you use Web connector. Web connector only support import mode. 

    If you use other connector to connect to your data source, you may refer to this blog for more details about supporting connection mode.

    Here is a offical blog about Power BI Rest API. For reference: Power BI REST APIs

    It seems that Power BI doesn't support you to change connection mode by API.

     

    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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi TexasBI 

        Power BI REST API doesn't support you to determine what mode the dataset is in Power BI Service directly.

        You could try Datasets - Get Datasources In Group to determind what data source your dataset contains. Find the connection mode the Power BI data sources support to determind.

        Here is a post that the user determind whether his dataset is Import or Direct Query by Set All Connections API.

        This API only support Direct Query.

        For reference: REST API Identification of Import vs Direct Query Datasets

        Or you can determind by the refresh way. For example, if your data source support Import/DQ or Import / Live connection, make sure the refresh way, schedule refresh(Import) or schedule cache refresh(DQ or LC). 

         

        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.