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 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.
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.