Forum Discussion
Manage Relationships Greyed out for Excel based Data
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)
5 Replies
- az38
Community Champion
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
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 🙂
