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,
I have a data model in excel (multiple tables with relationships). when I import the excel into power Bi, it doesn't keep the same structure rather it links the tables using columns of the same name. it seems that power bi doesn't recognize the structure if tables built in excel.
Is there any way to import the full structure?
Hi,
I'm pretty sure that Power BI will try and build associations itself, if the relationships that Power BI has created are not correct then you can go create/amend the relationships yourself in the Relationship/Modelling View.
Thanks
DJ
Proud to be a Super User!
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.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |