Forum Discussion
infantpowerbi
Helper II
Helper IIError on unpivot the data for selected columns in edit query
Dear All, I am infant to Power BI and my data is in below format. Company Q2 FY 2018 Q3 FY 2018 Q4 FY 2018 Q1 FY 2019 Q2 FY 2019 Q3 FY 2019 X 0 0 ...
Hi @infantpowerbi ,
The error pops up because Power BI will automatically create relationships. You could change it to many-to-one between MYT and Mytable. Or you could delete the relationship.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-xuding-msft
Community Support
Community SupportHi @infantpowerbi ,
The error pops up because Power BI will automatically create relationships. You could change it to many-to-one between MYT and Mytable. Or you could delete the relationship.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.