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

[Anonymous]

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

[V-pazhen-msft]

@Anonymous 

Please refer to this doc: Merge or append on-premises and cloud data sources - Power BI | Microsoft Docs

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

In your gateway management page make sure this is checked.

[venkatesakumar]

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]

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

[venkatesakumar]

Hi

I couldnt find the options in the settings of personal gateway.

Thanks

[lbendlin]

Use a standard/enterprise gateway if you can.

[Anonymous]

Thank you @lbendlin your solution did the trick!