Model section is locked. Cannot drag to create relationships.

[Anonymous]

Hello.

As you can see in this picture, the model section where I create relationships between tables is locked. Strangely, this happened only with the data pulled from the web. If I link power bi to a file (excel or csv), everything is fine. In that case (getting data from the web), I can only use the relationship editor.

Moreover, if I make a new layout, the model section is not locked, but when I try to move around the tables the section will lock immediately.

I also re-installed the application and this problem is still there.

The version that I am using: 2.79.5768.1082 64-bit.

Later edit: If I connect Power BI to a SQL Server database, the model section is active, but if I try to create some relationships between tables it does not show me in the diagram the line that is connecting one field to another.

[amitchandak]

Quite a few users have faced this issue with Match 2020.

Few were resolved. After saving Unsaved relations. The table in relation to was deleted saved, close and open.  Or the Connection changed from Import to Live or direct.

Please check and log a ticket at: https://community.powerbi.com/t5/Issues/idb-p/Issues

[Anonymous]

Thank you for your response.

I will log a ticket.

[v-yingjl]

Hi @Anonymous ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.