Reply
KFP
Helper I
Helper I
Partially syndicated - Outbound

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! 

1 ACCEPTED SOLUTION
KFP
Helper I
Helper I

Syndicated - Outbound

It turned out it was because I used an outdated gateway. The problem was solved after updating the gateway. 

View solution in original post

4 REPLIES 4
KFP
Helper I
Helper I

Syndicated - Outbound

It turned out it was because I used an outdated gateway. The problem was solved after updating the gateway. 

Syndicated - Outbound

I am also facing same issue. Can you help, how you solved this issue.

v-qiuyu-msft
Community Support
Community Support

Syndicated - Outbound

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
Super User
Super User

Syndicated - Outbound

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...
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

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.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric Community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)