Relationship view not editable

[BYENER]

Hi All,

Since few days I can not edit something in the relationship view, everything is grey and I cannot click relations.

Do someone know what is happened here?

[v-easonf-msft · Accepted solution]

Hi , @BYENER 

I have seen a similar post, and its solution is as follows:
Copy pasted all the data sources in a new powerbi desktop file and  it works..

Maybe you can take a try.

https://community.powerbi.com/t5/Desktop/Model-tab-all-greyed-out/m-p/986988

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-easonf-msft · Accepted solution]

Hi , @BYENER 

You can copy paste all data sources in the query editer (ctrl +c , ctrl v). 

Then you need to recreate your relationship in Relationship view.

In the end , you can  copy visual from one pbix file to another pbix file (ctrl +c , ctrl v).

Best Regards,
Community Support Team _ Eason

[amitchandak]

Seem like quite a few users are facing this. The only solution I have observed that the connection type changed to Live Query.

[BYENER]

What will be happened with my existing queries and measures? I never worked with a live query option.

[amitchandak]

It seems to have changed without user doing it or by mistake.

[BYENER]

All tables have storage mode : Import

I think that there is another issue, but what ? 

[v-easonf-msft]

Hi , @BYENER 

Can you show me your version of  Powerbi Desktop?

Is it just a problem with this report or all of your reports?

Best Regards,
Community Support Team _ Eason

[BYENER]

I have the same version. No, only one report.

[v-easonf-msft · Accepted solution]

Hi , @BYENER 

I have seen a similar post, and its solution is as follows:
Copy pasted all the data sources in a new powerbi desktop file and  it works..

Maybe you can take a try.

https://community.powerbi.com/t5/Desktop/Model-tab-all-greyed-out/m-p/986988

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BYENER]

Hi @v-easonf-msft ,

Thank you! One little question,copy paste all data sources. Can I do this in the query editor? And does this means that I have re-create the visuals?

[v-easonf-msft · Accepted solution]

Hi , @BYENER 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.

Other community members will easily find the solution when they get the same issue.

Best Regards,
Community Support Team _ Eason

[v-easonf-msft · Accepted solution]

Hi , @BYENER 

You can copy paste all data sources in the query editer (ctrl +c , ctrl v). 

Then you need to recreate your relationship in Relationship view.

In the end , you can  copy visual from one pbix file to another pbix file (ctrl +c , ctrl v).

Best Regards,
Community Support Team _ Eason