Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a dataflow setup that queries Salesforce via an ODBC connection on our gateway.
The dataflow refreshes succesfully but when i refresh my report from the dataflow, some of the entities are missing all of the fields. This doesn't happen to the same entities each time:
Is anyone else experiencing this issue?
Solved! Go to Solution.
Resolved.
This issue was likely linked to another issue I was having with a datasource set up in our gateway cluster. The other issue descibed here - https://community.powerbi.com/t5/Service/Dataflow-Refresh-Error-ODBC-ERROR-HY000-Showing-a-modal-dia... - caused some instability with dataflows that used that datasource.
Resolved.
This issue was likely linked to another issue I was having with a datasource set up in our gateway cluster. The other issue descibed here - https://community.powerbi.com/t5/Service/Dataflow-Refresh-Error-ODBC-ERROR-HY000-Showing-a-modal-dia... - caused some instability with dataflows that used that datasource.
Thanks for your response.
This happens right after a successful refresh though. When I refresh the dataflow, other entities lose their fields. There are no errors in the dataflow itself either.
Supposedly you need to refresh the dataflow in the service to make these fields appear.