Forum Discussion
Service Gateway Updates Fails while working in Desktop (Service settings are ok)
Hello, I've created a custom function that retrieves dynamically queries values from a sharepoint excel file and execute in Oracle DB creating a custom column in power query, which works fine in des...
Hi mpros ， hello lbendlin and Poojara_D12, thank you for your prompt reply!
You can use the on-premises data gateway to merge or append on-premises and cloud data sources in the same query.
Please try to select the gateway you want to configure, and select Settings from the top ribbon.
Under Settings, select Allow user's cloud data sources to refresh through this gateway cluster, then select Save.
More information for your reference:
Merge or append on-premises and cloud data sources - Power BI | Microsoft Learn
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dear Anonymous ,
Gateway is already set up as you were mentioning:
Error in update still occurs.
Ciao