Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hello there,
I have a power bi file that takes in data from 4 excel files - Calendar, Product, Location, Sales, and Stocks along with some visuals.
these tables are connected with Relationships.
the Situation is I get a different dataset with the same excel file names, with this I would want to change the dataset but retails the relationships between them. how can I do that?
whenever I remove the existing table and replace it with the new one, the relations are lost and I have to connect them back.
EX: I remove the existing Products table and then upload a new Products table, the relationship is lost.
Solved! Go to Solution.
If the column names and table structures are the same, change the data source file in Power Query
Proud to be a Super User!
Paul on Linkedin.
If the column names and table structures are the same, change the data source file in Power Query
Proud to be a Super User!
Paul on Linkedin.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
100 | |
64 | |
44 | |
37 | |
35 |