jengwt on 13 Apr 2018 21:32:40
I have found that appending tables from mixed sources (as opposed 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 you have 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."
The only exception seems to be if you have an appended table pulling from a static table and a connection. But that makes sense.
This seems like pretty basic functionality that should already be included as part of gateway-data refreshing.