Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Gateway connection for multiple data sources

Hi All,

 

Actually i had developed a report that contains multiple datasources such as power bi datasets, SQL server, python scripts and i published to the service and our admin has created gateway connections for SQL server because it is on premises and for remaining data sources i know that enterprise gateway will not support for python script and for power bi datasets no need of gateway creation but for power bi datasets it is asking gateway connection. So i want to know why it is asking gateway connection for Power BI datasets and i think may be it is asking due to Python data source used in Power BI desktop or any other reason.

Thanks in advance.

Show and Tell

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    3 years ago

    Hi Anonymous 

     

    The reason that as soon as you combine multiple datasources if one of those data sources need to go via the On-Premise gateway some of them then also need to go via the Gateway.

     

    What you can do is to check under Data Source settings, sometimes there is an option to edit the credentials there, even though it is asking for it via the gateway.


    Here is an example below.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi GilbertQ ,

      Thanks for the response as you suggested i checked 

       under Data Source settings, but there is no option to edit the credentials there.

       

       

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        3 years ago

        Hi Anonymous 

         

        I would suggest making sure you can edit the credentials in order to successfully refresh.

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi Anonymous ,

     

    Here is a summary of important facts about Power BI datasets that represent models:

    • SQL Server Analysis Services hosted models require a gateway to perform live connection queries.
    • Power BI-hosted models that import data:
      • Must be fully loaded into memory so that they can be queried.
      • Require refresh to keep data current, and must involve gateways when source data isn't accessible directly over the internet.
    • Power BI-hosted models that use DirectQuery storage mode require connectivity to the source data. When the model is queried, Power BI issues queries to the source data to retrieve current data. This mode must involve gateways when source data isn't accessible directly over the internet.

     

    For more information, please refer to:Datasets in the Power BI service - Power BI | Microsoft Learn

     

    Best regards,

    Yadong Fang

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