Forum Discussion
on premises gateway offline for Users
Hi All,
For me the issue is solved this morning without any modification on my side.
And for you sayaliredij ; rubensalvador and Salonic ?
Thanks
David
rubensalvador Coincedently yes. I just ended a call with a staff member where we got this issue. In our case we had 3 SQL databases in the project but only 1 of them existed in the gateway. Normally Power BI wouldn't allow you to select this gateway unless 100% of the datasources exist in the gateway. Recent editions allow you to refresh cloud sources through the gateway so its likely possible this new symptom is related to that.
My advice is to open the Project in your Power BI desktop, find the "Edit Queries" button, which has a drop arrow. Click on the drop arrow and select "Data Source Settings". Make sure each entry in this list is captured identically in your gateway. This being that any server/database names are identical. If they are referenced by IP address or Servername that you use the same method. If the sources are on a network folder, make sure they are in the format of "//Server/Folder" instead of "C:\Folder\"
Anonymous, I'm not in your situation of multiple sources and have the issue. Nobody can publish or change a report already published. Any idea of the cause ?
In our case, once we got all of the data sources corrected in the gateway, that error went away.