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.
Hello! We have started having performance issues with our dataflows, so I am trying to follow best practice and separate our dataflow into a "staging" dataflow and a "transformation" dataflow per this documentation: https://learn.microsoft.com/en-us/power-query/dataflows/best-practices-for-dimensional-model-using-d.... However, in the "transformation" dataflow (which is linked directly to the tables I need from the "staging" dataflow), I'm getting an error that linked entities cannot have any transformations done on them. Am I configuring this wrong?
Solved! Go to Solution.
In your transformation dataflow, reference the linked entity (right click on linked entity and select reference) and make your transformations on the reference query.
In your transformation dataflow, reference the linked entity (right click on linked entity and select reference) and make your transformations on the reference query.
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.