I was trying to refresh a report in the service that uses the Adobe Analytics connector and a on-prem database using the gateway, but kept getting this error:
Underlying error message: [Unable to combine data] <removed> references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
I have "Ignore the privacy levels" checked in my report settings, so I thought this was pretty strange.
I was also seeing this error in the on-prem data gateway logs:
Failed to read GatewayCore property: EnableFastCombine, Ex: Object reference not set to an instance of an object.
I found page, talking about adding something to the config file in the personal gateway:
Even though it says this fix is for personal gateway, I thought I'd try it--and it fixed the issue.
I added the following to "Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config":
<setting name="EnableFastCombine" serializeAs="String"> <value>true</value> </setting>
And now my reports are refreshing.
Thanks for your sharing.
FYI, this change gets removed from "Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config" when a new verison of the gateway is installed and has to be reapplied.