Manage Relationships Greyed out for Excel based Data

[Anonymous]

I am using an excel file that has multiple sheets. I am able to load data and create relationships manually. But it appears when I go to the manage relationsips the screen is greyed out & i am not able to see the visual or change my relationships.

This is happening with the version  2.79.5768.1082 64-bit (March 2020)

[az38]

Hi @Anonymous 

there is a solution with just refreshing the data 🙂 https://community.powerbi.com/t5/Desktop/Manage-Relationships-not-working/m-p/681190

try it

[Anonymous]

Tried it already before posting this. To be clear Even earlier I was able to manually create the relationships I am not able to see them visually. The tables are not arraged & Joins are not visible if you look at the screen shot and this is not just me but a couple of other folks as well in the Organization who are on this latest version.

[az38]

@Anonymous 

you can remove all sensible data and share your pbix to the cloud

also, I see the only table. did you try to move it to the other part of the screen? Sorry, for such a stupid questions, it's often be a stupid solutions 🙂

[Anonymous]

Tried moving the small block thats visible and the greyed out portion does nothing.  I am getting the feeling of BUG 🙂 

Dataset contains all kinds of senstive data, let me create a dummy one, replicate the issue and share.

[v-lionel-msft]

Hi @Anonymous ,

Could you successfully refresh the data? Please try to refresh your data.

Best regards,
Lionel Chen

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