Forum Discussion
Helper IPower BI Model Relationships gone on updating PowerQuery
After updating a table in Power BI Desktop PowerQuery all relationships related to this table are gone and needs to be done again. Same with any measures created on top o this table.
The update on the PowerQuery did not affect the output/load but only the source and transformation.
How come this breaks the relationships of the table when the load is strictly identical to the prior version?
Actually I think I've found the solution. Just separating the load table from the staging (extract and transform) allows to swap sources and transformation without breaking the model.
Hi Guillaume_,
I am so glad to hear that your problem has been solved . Please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Yadong Fang
2 Replies
- Guillaume_
Actually I think I've found the solution. Just separating the load table from the staging (extract and transform) allows to swap sources and transformation without breaking the model.
v-yadongf-msftCommunity Support
Hi Guillaume_,
I am so glad to hear that your problem has been solved . Please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Yadong Fang