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.
Let's say I have two tables in a database, Sales and Sales_Detail, that have a defined primary / foreign key relationship. I've noticed when pulling the Sales_Detail into Power Query that I get the option to "expand" columns from the Sales table.
However, if I place a view directly on top of the Sales_Detail and pull that into Power Query instead, I lose the ability to still expand columns from the Sales table. I imagine this is because Power Query doesn't introspect the view to see the relationships behind it, but is this documented anywhere or alternately is there a way to explicitly tell the Power Query editor to allow expansion of Sales columns in the view?
Solved! Go to Solution.
You can just do it manually. Load both tables in Power a Query and do a merge on the key, then you can expand from there.
we generally advise our developers to switch off all the automatic field type and relationship detection options. Oftentimes these options lead to questionable results.
The developers need to know their data models, and they need to make these decisions themselves.
You can just do it manually. Load both tables in Power a Query and do a merge on the key, then you can expand from there.
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.