cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
simmi0505 Frequent Visitor
Frequent Visitor

Unable to open document - many-to-many or composite model

Hi.  Relatively new to Power BI and would appreciate any help.  Created a new report using 2 sources - import of SQL tables and Excel file.  Report completed and worked great.  Closed the file and reopened later to get the following error message:

 

image.png

 

The file was pretty straight forward, should have no many to many relationships.  But I cant get into it to make any changes for find out what is wrong.  Is there any way to get back into it?

 

Thanks

 

Simon

 

 

 

 

 

2 REPLIES 2
Highlighted

Re: Unable to open document - many-to-many or composite model

Well clearly it shouldn’t happen if you created the model with the same client. How old is your version of desktop?  The report server version normally runs up to 5 months behind the normal version. Depending on your org, you could be several versions behind. If you have an old version, you won’t get support I guess. I would update to the latest report server version. If the problem persists, then open a support ticket. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
simmi0505 Frequent Visitor
Frequent Visitor

Re: Unable to open document - many-to-many or composite model

Hi. Thanks. I created and tried to reopen on the same client. Unfortunately getting my organization to allow the latest version isn’t simple.

Could I download the lastest version outside my organization on a different computer, open the file and make the changes? Or would that not open when I go back to the organization version?

Thanks

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors