Post by tonystrak on Dec 28, 2017 23:42:57 GMT -5
Hi,
I have two tables from two different SQL servers and I wish to append one table to another. Everything worked fine until I uploaded the report and tried to refresh. Then it failed and said "There was an error in the data gateway". I use an enterprise gateway. I have tried setting all data sources' privacy level to "None" and it still didn't work. Pretty sure the issue came from appending the queries because if I deleted the step "Append Queries" and reuploaded the report, the data refresh worked fine.
Based on my test, I connected to two SQL databases from the same instance in desktop use Import mode, and set both data sources Privacy Level as Organizational. The two data sources created under on-premise data gateway also set as Organizational Privacy Level. After published the report to service, it's able to be refreshed.
Thanks!
For more details:
Pharmaceutical Advertising Video
I have two tables from two different SQL servers and I wish to append one table to another. Everything worked fine until I uploaded the report and tried to refresh. Then it failed and said "There was an error in the data gateway". I use an enterprise gateway. I have tried setting all data sources' privacy level to "None" and it still didn't work. Pretty sure the issue came from appending the queries because if I deleted the step "Append Queries" and reuploaded the report, the data refresh worked fine.
Based on my test, I connected to two SQL databases from the same instance in desktop use Import mode, and set both data sources Privacy Level as Organizational. The two data sources created under on-premise data gateway also set as Organizational Privacy Level. After published the report to service, it's able to be refreshed.
Thanks!
For more details:
Pharmaceutical Advertising Video