Forum Discussion

mpros's avatar
mpros
Helper I
1 year ago

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...
Need Help
mpros's avatar
mpros
Helper I
1 year ago

Dear,
have already tried to add a gateway connection for cloud ds. Doesn't work either. 
Ciao

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

  • mpros's avatar
    mpros
    Helper I
    1 year ago

    Dear Anonymous ,
    Gateway is already set up as you were mentioning:

    Error in update still occurs.
    Ciao