Corrupt PBIX and Cannot Load model Error Message Stuck in Continuous Loop

[Anonymous]

Some weird things have been happening here. 

So, firstly, and most importantly, I was playing around with adding a R visual without the necessary files. Not sure if this corrupted my file but now if I look at the report on the service it's fine, but the version I download from it is an older version. 

Secondly, when I open the PBIX file it prompts for the following and is stuck in a continuous loop I can't dismiss. We did move our server and I changed the source in the latest version of the report and published it, it's just the local desktop version that can still see the old datasource...no idea why. Any ideas on how to stop this error occuring.

[Pragati11]

Hi @Anonymous ,

Can you try downloading the pbix file from Power BI service which is the latest one that you published with new connection details and check? 

If this helps please give Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[Anonymous]

Hi, thanks for the prompt reply and apologies if I didn't make myself clear but I meant I download that version and I still get the same issue.

[Pragati11]

Hi @Anonymous ,

Is this database at a different location rather than your local machine?

Thanks,

Pragati

[Anonymous]

Hello, its a different Server and instance of SQL SSAS Tabular DB that I've moved to. What's strange is I switched it all over on Monday to the new one. Worked fine. I then opened it yesterday and it's still pointed to the previous one. I'm wondering whether there's a way of overcoming this error message and get to the datasource settings instead of being faced with a continuous loop as seen above.

[v-shex-msft]

HI @Anonymous,

I think you are working with live mode(direct query, live connection) data sources, right? If this is a case, I'd like to suggest you check the connected status first. (live mode requires to keep the connection to database, if power bi can't link to Datasource, they will display the error message for connection failed)

Regards,

Xiaoxin Sheng