Forum Discussion
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 0 0 0 0
Y 0 0 0 0 0 0
Z 1 2 0 4 5 0
All 0 1 3 4 2 5
And when I unpiviot for selected columns(Q2 FY 2018 Q3 FY 2018,Q4 FY 2018 , Q1 FY 2019 , Q2 FY 2019 , Q3 FY 2019) in Edit Query I get the below error . Can any one please help in knowing what's the issue and how can I solve it
Error
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.
6 Replies
v-xuding-msftCommunity Support
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.
infantpowerbiJagdesh,
Tq for your kind and gentlesupport,Please find the below link and you can find the table MYT in dataset
https://www.mediafire.com/folder/rp3zlge0rx64x/
Tq and regards,Siddiq.
