- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can't refresh data after appending queries
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.
Can anyone help? Thanks!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It turned out it was because I used an outdated gateway. The problem was solved after updating the gateway.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It turned out it was because I used an outdated gateway. The problem was solved after updating the gateway.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am also facing same issue. Can you help, how you solved this issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @KFP,
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.
In your scenario, can you share more information for us to reproduce the issue in our environment?
1. How did you connect to two different SQL servers? Two database in different instances or the same instance?
2. How did you set the Privacy Level for data sources in desktop?
3. How about the Privacy Level setting for data sources under data gateway?
Best Regards,
Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That definitely sounds like something that should be reported as an Issue. http://aka.ms/issues.powerbi.com
I haven't run into that myself, but I also can't think of an instance I have appended two SQL tables together.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Subject | Author | Posted | |
---|---|---|---|
10-20-2022 06:44 AM | |||
06-17-2024 06:37 AM | |||
Anonymous
| 12-20-2023 12:09 PM | ||
11-08-2023 11:00 AM | |||
07-08-2023 03:49 AM |