Forum Discussion
Power BI Hangs on Loading Data to Model
It seems that a reboot of the machine running PBI desktop fixed the issue. I got prompted for a Windows Update and after install of that update the issue went away. Had nothing to do with firewall or network traffic (that didn't seem logical to me since I could preview the data and communicate with the SQL Server using Direct Query and also I could work with the data in Power Query). Anyway I hope this helps someone else.
Memorable MemberHi RAC_GAVIN,
I cannot say for sure why this is happening in your case but you might want to take a look at the hosts that are allowed to access your DB. I think you should check if Power BI URLs are whitelisted or not.
Links that might be helpful:
https://learn.microsoft.com/en-us/power-bi/admin/power-bi-allow-list-urls
https://www.microsoft.com/en-us/download/details.aspx?id=56519
Mark this post as a solution if that works for you!