Forum Discussion
Helper IUnable to set enterprise gateway for data source after publishing
Hi kjohn10
That would often happen when one of the sources is not configured in the On-Premise Gateway.What I would suggest doing is to open your Power BI Desktop file and click on Data Source Settings. See how many data sources you have in there, and then see how many you have and how they are configured.
Then ensure that you have the identical setup in the Power BI On-Premise data sources in the service.
Super UserHi kjohn10
That would often happen when one of the sources is not configured in the On-Premise Gateway.
What I would suggest doing is to open your Power BI Desktop file and click on Data Source Settings. See how many data sources you have in there, and then see how many you have and how they are configured.
Then ensure that you have the identical setup in the Power BI On-Premise data sources in the service.
kjohn10Thanks. Looks like it came down to the "Authentication Method" configuration; In desktop, all 3 feeds were set to 'Anonymous', but in powerbi.com 2 of the 3 were set to 'Windows' auth. Changing those 2 to 'Anonymous', and now I was able to select the gateway for scheduled refresh.
Just tried a scheduled refresh, and it failed. All I got was "Oops, something went wrong." email notification. The [Learn More] link leads to a page full of random stuff to check and try, yikes. Off to troubleshoot more. I wish the email had a little more detail as to what "went wrong".
You may want to review the article for configuring the enterprise gateway. We ran into a similar issue with non-descript failures until we discovered we did not have the correct ports open for the enterprise gateway.
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem/
- kjohn10
Thanks for the tip, however we've had various other reports working fine with scheduled updates. I'm working on getting access to the server where the gateway is installed to enable detailed logging and see what gets captured.