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.
User | Count |
---|---|
103 | |
83 | |
68 | |
47 | |
47 |
User | Count |
---|---|
155 | |
91 | |
82 | |
69 | |
67 |