Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a column to which I expanded to get more data but when saving changes and applying them, I get an error:
Hi @Dymension ,
When you expanded the new columns you have multiple results, so what happens is that each line from the original table is duplicated for those lines that are expanded. From the error you are using a column from that table has part of a relationship on the one side.
For this you need to debug you table to check what is the repeated values, I would do a Group by on the column identified in the error and check wich ones are getting more than 1 value and the correct the data accordingly to your needs.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |