PBI Desktop stuck forever on 'Loading data to model' step

[Anonymous]

Hi!

When loading changes from Porwer Query or trying to refresh data, PBI stucks forever on the 'Loading data to model' step...

This started to occur in a moment... I mean, I hadn't made any installation, upgrade, ec of PBI or any other software.

At first, I though it happenned because there was too many queries in Power Query (like 200), but I've checked that it happens now even with a new file when trying to load an empty query.

I've tried to clear the caches, deactivate all options about creating automatic realtionships, re-installing it, installing older versions and don't know what else to try.

As I said, this happens now to all my pbix, even a new one with an empty query.

Any suggestion will be very welcome since I'm starting to lose my mind! 😕

Thanks in advanced!! 🙂

[MichelleLe]

Hi there - just wondering if you manage to resolve / determine root cause? As I think I am experiencing something similar. Out of the blue, nothing is refreshing anymore 😫

[Anonymous]

Hi!
I'm afraid I haven't find a solution o recieved and answer... In fact, I'm working with June 2021 PBI realease wich works fine for me...
I should try with a new release, but I live in fear... xDDD

Sorry cannot help you... 🙂

[parry2k]

@Anonymous very weird, can you manually enter data in power query and then load it. Seems like something specific to your machine. Any AV is causing this? 

[Anonymous]

@parry2k , everything seem to work fine on the PowerQuery side (it evaluates, processes and shows complex queries, get data from online and local sources and so). I've tried with empty queries and tables created manually and the issue is the same, blocked when applying the changes.

PowerQuery seems to work fine when using it whit Excel and loads the changes.
As antivirus, I'm only using the Windows antivirus...

[Anonymous]

Hi @Anonymous ,

I have a test by add Query in Enter data in 2.100.1182.0 64-bit version (latest version), it works well.

What data source are you trying to connect to? 

PowerQuery seems to work fine when using it whit Excel and loads the changes.

Do you mean that Power BI Desktop could load data successfully when you connect to Excel?

Please download the latest desktop version and try agian.

Best Regards,
Rico Zhou

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

[Anonymous]

Hi,

as I said in previous msgs, the issue happens even with no data connection. It happens even with an empty quey o a manual table.

This started while using the lastest version and I've also tried previous versions.

After a complete formating by my IT service, it keeps happenning so I've change to another computer.

[_dh]

Hi, I am facing the same issue and have an interview tomorrow. How did you resolve this?

[parry2k]

@Anonymous there is a new infrastructure option in the option and settings, can you try to turn that off  or vice versa.

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[Anonymous]

Thank for your response @parry2k!

That is the feature about the future implementation of WebView2, isn't it?
I've already tried to uncheck the option, to reinstall WebView2 again or even remove it completely, but it keeps stuck loading data... 😕