Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to referesh table joined from on prem SQL-Server and dataflow in cloud service?

Hi,

I have a table in Power BI that is joined from a on Prem SQL-Server with a dataflow in the Power BI Pro cloud. I have a gateway set up so that the cloud can access the on prem SQL-Server. But when I refresh the dataset with the joined table in Power BI cloud service, then this error occurs:

COM error: Microsoft.PowerBI.AS.ConnectionDetailsProvider, Refreshing cloud & onprem datasources, but the gateway doesn't allow cloud datasource refresh.

How can I set up this refresh so that it works?

 

Thank you very much!

 

BR
Martin

Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    In your gateway management page make sure this is checked.

     

7 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    In your gateway management page make sure this is checked.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you lbendlin your solution did the trick!

    • venkatesakumar's avatar
      venkatesakumar
      New Member
      3 years ago

      Hi Ibendlin,

       

      I am having a problem to enable my personal on premise gateway for cloud data connection.

      how can i reach the setting explained in your email?

      Thank you

      Regards

      Venkatesa Kumar

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        Go to Power BI  the gateway management page, then select a gateway and click on settings.