Forum Discussion
Gateway Source Issue
Your folder paths match, so my next troubleshooting step would be to check the "Data Source Settings" button in Power BI Desktop. This should give you the concise listing of all of the data sources in your Power BI file. Chances are there is one in there that isn't properally configured in your gateway.
Your folder paths match, so my next troubleshooting step would be to check the "Data Source Settings" button in Power BI Desktop. This should give you the concise listing of all of the data sources in your Power BI file. Chances are there is one in there that isn't properally configured in your gateway.
Anonymous
Spot on. I double checked those settings and discovered the report creator moved the folder to shared drive after creating the report. They pointed the connection to the new file location but the function included in the folder import still had the original connection hidden in it. Therefore, when I checked the query editor and looked at the actual queries it was correct but when I checked the settings, the other, old connection was retained in the function. A quick fix to replace and now I have a functioning connection.
My report was working fine, gatway was and still working "good to go", the report was on 2 hours schedule and did refresh three times before blessing me with this issue. no data source changed, nothign wrong with gateway, i have no other data source than sql server directquery "import". Tried to walk on yalls footsteps but so far no luck. where is this "creater" that i am supposed to move? I need help please.
AHussain Have you ruled out that its not just a temporary hiccup? If a refresh or two have failed then I wouldn't start to panic yet unless you are getting an error specifically saying the data source can't be found.
In the case mentioned here, the directory holding the data source was changed.
