Forum Discussion

RafalGabin's avatar
RafalGabin
Regular Visitor
8 months ago
Solved

Refresh problem

Today after adding excel file from Sharepoint merged with data from MS SQL Server (data from MS SQL Server connected throught gateway on server) I noticed error when I wanted to refresh data: {"e...
Need Help
  • rohit1991's avatar
    rohit1991
    8 months ago

    Hii RafalGabin 

     

    That error appears because your dataset now mixes a cloud source (SharePoint) with an on-prem SQL Server (gateway) and the gateway is not configured to allow cloud data source refresh in mixed-mode queries. When you added the new Excel file and merged it with SQL Server, the model became a “combined” data source, and the refresh is blocked.
    To fix it, go to Gateway >> Settings >> Allow user cloud data sources to refresh through this gateway and enable it (or move the SharePoint file into a Dataflow so the dataset only refreshes from the gateway). Once the gateway allows cloud + on-prem mixing, your scheduled refresh will work again.

v-tejrama's avatar
v-tejrama
Icon for Community Support rankCommunity Support
8 months ago

Hi RafalGabin ,

 

Thank you Zanqueta , MasonMA and rohit1991 for the helpful input!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your support!