Forum Discussion
Solved
enterprise gateway refresh error
The data refreshes fine using desktop and publishes with no problem. Getting the error below when refreshing from the cloud. I see the SQL commands are hitting my db. So how to I troubleshoot this fu...
The Gateway status is fine. I resolved this by deleting the report and dataset, and republishing both.
I found a bug with the Enterprise Gateway.
- I built a dashboard on my destop using 2 data sources and manipulated my data using "Merge Queries."
- The two data sources are both established on the Enterprise Gateway
- On my desktop I was able to refresh all data sources and had a viable and working dashboard
- When I published the dashboard to powerbi.com and set it up on the enterprise gateway it would not refresh. the error I got is noted in my original post.
- As an experiment I created 2 test queries using the same data sets. One using "Merge Queries" and one using "Merge Queries as New." Both tests were able to refresh on the desktop but not using the enterprise gateway.
- So I decided to do a 3rd test by simply creating a one-to-many relationship between the two data sets and this worked fine using the enterprise gateway.
I am assuming this is a bug. Has anyone else experienced this phenonmenon when using "Merge Queries" or "Merge Queries as New?" I should be able to use all the querying tools on the desktop version and as long as my data sources are set up on the enterprise gateway my dashboard should be able to publish and refresh through that gateway using all the functionality I use on my desktop.