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.

ritaok's avatar
ritaok
Regular Visitor
4 months ago

Hello PowerBi Experts, 

 

I have following this issue can someone please guide how to solve this issue in service.

I currently have my data connected through 3 sources: SQL, Sharepoint and Odata (for my HRIS system). And during refresh i keep getting this error message. I read other posts that recommended adding sharepoint as a gateway but is that applicable in this case since i have a 3rd connection. 

I appreciate the guidance