Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
FYI this work-around is no longer working for me with the July 2019 version of the Gateway.
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.
Hi @jeffshieldsdev,
Thanks for your sharing.
Regards,
Daniel He
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.