Forum Discussion
stucking on creating connection in model
Leann,
Do you choose “Import” or “Connect Live” mode to connect to SSAS database in Power BI Desktop? I would recommend uncheck the following options in Power BI Desktop and then refresh your data model.If the above error still occurs, please try to re-connect to the SSAS database in Power BI Desktop, pull in columns and rows you need to build report.
Regards,
Lydia
Leann,
Do you choose “Import” or “Connect Live” mode to connect to SSAS database in Power BI Desktop? I would recommend uncheck the following options in Power BI Desktop and then refresh your data model.
If the above error still occurs, please try to re-connect to the SSAS database in Power BI Desktop, pull in columns and rows you need to build report.
Regards,
Lydia
Hello,
Tried the Solution above, still doeswn't work. Stuck at Creating Connection in Model.
This is happening after September2021 update of PowerBI Desktop.
I tried degrading to previous version of Power BI Desktop(August2021) Version. It is fixed now.
Regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
How did you downgrade the version?
- linh091
Resolver I
Anonymous
You need to uninstall your current desktop version, then download one of these versions to re-install
August 2021 version of Power BI Desktop - 64-bit:https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDesktopSetup-2021-08_x64.exe
August 2021 version of Power BI Desktop - 32-bit:
https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDesktopSetup-2021-08.exe
I am stuck on this as well. Tried following above steps but didn't resolve the issue. I would rather not downgrade my version.
MattGellAdvocate I
OK so its obviously from the upgrade as it happend to all my files in since September to.. but it still needs fixing. But at least I know now thank you.
This is still not resolved even after October Update.
i tried every thing mentioned in this thread.
I have August Version Installed and it works perfectly fine.
But the Version from Microsoft Store (Oct 2021) still having issues and is stuck at Creating Connection.
Please help! Anonymous
Hi can you tell me how I download the August version ?
Hi LyidaAnonymous,
Thanks a lot for your help. After I disable the features you mentioned plus "import relationship from data source", I can load the table smoothly. :-)
I found the cause might be the new source of the dimension table contains duplicate rows, it caused the hang on problem.
one more question, if I refresh the data from power bi service, will it check the relationship as well? or is related to what I set in the option power bi desktop? Thanks for your answer. :-)
Have a nice weekend!
LeAnn
I have the same problem, I followed the same steps as in your proposed solution, but i'm still having issues refreshing the data.
Can anyone help me?
I cannot refresh my data. Creating connection in model never finishes. See printscreen. Data source settings are adjusted due to changed network name but oke now. It has always worked before.
Still no luck after doint that. only difference is mine works and loads but its stopped telling me how many rows are being loaded?
beware of "--comments"
I had this problem and when I viewed my cache, I noticed it was full. After clearing my cache the data loaded without further trouble. With your pbix navigate to File>Options and Settings>Options>Global>DataLoad>Data Cache Management Options>Clear Cache
