Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jengwt
Helper V
Helper V

Mixed-Source Appended Tables break Gateway-Data Refresh

I have found that appedning tables from mixed sources (as ooposed to homogenous sources) breaks the PBI Service's Data-Gateway refresh functionality.

For instance, an appended table pulling from two DB2 tables and an appended table pulling from two Dynamics Odata tables will both refresh just fine when published to Service. However, if one has an appended table using both DB2 and Dynamics sources, the dataset manager complains, "You don't have any gateway installed or configured for the data sources in this dataset. Please install a new data gateway, or configure the data source for an existing data gateway."

We use an on-prem gateway, not a personal one.

In desktop, all combinations of appended tables work just fine, so it's not that the connections aren't valid.

The only exception seems to be if you have an appended table pulling from a static table and a connection. But that makes sense.

 

I suppose this is more Idea-worthy. This seems like some pretty simple functionality that should be able to exist.

2 REPLIES 2

@jengwt Are you running the latest Gateway on the Server? If not, what version are you using?


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

@Seth_C_Bauer We actually just updated our Gateway this weekend. It has not had an effect.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors