cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver II
Resolver II

November(2017) update cannot connect to data model

Hi,

 

Since updating desktop to the latest version as of 11/9/2017 I tried to switch data source of one my reports to a test version of the same model. This process has worked well before. However this time, upon switching the live connection to the test model, no data came through and all of my visuals broke.

 

I have tested on colleagues computers who have not updated and they have confirmed that the test model and report work perfectly.

 

I have also rolled back to the October update of Power BI and again, everything works perfectly. So we seem to have isolated the problem as being something (at least) to do with the November 2017 update.

 

Has anyone else experienced this issue? How do I escalate this properly?

 

Thanks,

 

Will

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: November(2017) update cannot connect to data model

Hello,

 

I have also experienced this issue when changing data connections after installing the November update. I copied the error and it is very ambiguous

 

Error Details:
An exception of type System.InvalidOperationException occured.

 

It broke every visual in the desktop file. Interestingly enough, when I published the file with the broken visuals to the service it worked perfectly in the service. I then saved the broken file and reopened it and my visuals started working again.

 

Hopefully the above is helpful in troubleshooting your issue.

 

Thanks,

James

View solution in original post

11 REPLIES 11
Highlighted
Resolver I
Resolver I

Re: November(2017) update cannot connect to data model

Hello,

 

I have also experienced this issue when changing data connections after installing the November update. I copied the error and it is very ambiguous

 

Error Details:
An exception of type System.InvalidOperationException occured.

 

It broke every visual in the desktop file. Interestingly enough, when I published the file with the broken visuals to the service it worked perfectly in the service. I then saved the broken file and reopened it and my visuals started working again.

 

Hopefully the above is helpful in troubleshooting your issue.

 

Thanks,

James

View solution in original post

Highlighted
Super User IV
Super User IV

Re: November(2017) update cannot connect to data model

I had the same issue when updated SSAS data source , but once I saved the file and reopened it, worked fine. 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Resolver II
Resolver II

Re: November(2017) update cannot connect to data model

Thanks for the replies guys, that trick with saving and reopening is a useful workaround I'll give it a go. 🙂

 

I feel like this issue is a bug of sorts and MS need to be informed but I don't know the proper channels, where's the correct place to raise this issue?

 

Thanks again,

 

Will

Highlighted
Resolver I
Resolver I

Re: November(2017) update cannot connect to data model

Hey @giblet17,

 

I posted this on the issue forum and linked back to this post. The mods over there are usually pretty good at responding and getting fixes. Microsoft will also tell you to log a support ticket, in my past experience the support ticket team will do everything possible to say the issue is "by design" or that the developer is doing something wrong so that they don't have to work it. If you want to try that path I hope you get a better experience.

 

James

Highlighted
Resolver II
Resolver II

Re: November(2017) update cannot connect to data model

Great, thank you very much James. I'll heed your warning and do my best to avoid the classic support circle.

 

Thanks again,

 

Will

Highlighted
Super User I
Super User I

Re: November(2017) update cannot connect to data model

I'd already popped in a support request before seeing this thread and responses so far have been to suggest the workaround identified above, so it would appear that news of this issue has propagated through various channels.

 

I'm personally finding this workaround a bit hit and miss, depending on the workspace my data models are deployed to - sometimes I can re-point/save/exit/reload without prolems and on some occassions it's managed to completely corrupt my report, although I can sometimes salvage thi sis I publish my model to a different workspace and repeat the workaround. I need to do a little more testing around this scenario and see if I can identify a bit more. 

 

With the Nov update not being particularly eventful in terms of changes I need and this particular issue being quite prominent in and dirsuptive to our workflow, I'm planning to downgrade to the Oct release once I've provided some more info to my assigned support person and I'm hoping that this one doesn't hang around for too long...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Resolver I
Resolver I

Re: November(2017) update cannot connect to data model

The admins over on the issues forum have confirmed this as an issue and have logged it internally with Microsoft. Hopefully a fix comes soon.

Highlighted
Super User I
Super User I

Re: November(2017) update cannot connect to data model

Support have confirmed with me that it is scheduled to be fixed in the next update, so presumably early next month.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Super User I
Super User I

Re: November(2017) update cannot connect to data model

Have just re-tested in the recently released Nov update (2.52.4921.682) and the issue seems to be resolved Smiley Happy





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors