Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello All,
Hope you are doing well 🙂
I need your help in sorting out the issue iam facing in Power BI . I have around 8-10 tables in Power BI on which i have to do unpivot column transformation on 4 tables . when i do the unpivot transformation , my relationships get changed to Many to Many for visuals to show properly .
it was working for sometime when iam doing these transformations but all of sudden file getting corrupted with the error as shown in below snapshot . same happened even after trying with two files.
Hi @Anonymous ,
Please open power query editor and check the preview (refresh preview) of each table and see which one is giving this error. And select File > Options and Settings > Data Source Settings to clear your data source credentials.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
try below links for help.
Solved: Couldn't load the data for this visual - Microsoft Power BI Community
Azure "cannot load the data for this visual" - Microsoft Power BI Community
Solved: Can't Display the Visual - Microsoft Power BI Community
Proud to be a Super User!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 159 | |
| 132 | |
| 118 | |
| 79 | |
| 53 |