topic Re: stucking on creating connection in model in Desktop

stucking on creating connection in model

Leann — Thu, 12 Oct 2017 08:15:30 GMT

Hi,

I have a data model in power bi desktop, the tables are loaded from ssas server, and it refreshed data well yesterday.

But today when I pulled in more data (400,000 rows to 17,986,280 rows) to ssas server, and click refresh data of the fact table (refresh only one table), it's stucking in "Creating connection in model" 1 hour...(still stucking)

Also, I've exmained the table which has no blank columns. is it normal?

or any experience to check the problem efficiently?

Thanks a lot!

Re: stucking on creating connection in model

Anonymous — Fri, 13 Oct 2017 03:26:58 GMT

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

Re: stucking on creating connection in model

Leann — Fri, 13 Oct 2017 11:13:58 GMT

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

Re: stucking on creating connection in model

gustavotorrealb — Fri, 11 May 2018 17:53:40 GMT

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?

Re: stucking on creating connection in model

Anonymous — Tue, 28 Jan 2020 10:57:06 GMT

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.

Re: stucking on creating connection in model

Sgandalf — Wed, 27 May 2020 18:52:11 GMT

Hi Hypeerchef1969,

I have also not been able to resolve my being stuck on "creating connection in model" using the options in the suggested solution above.

Have you managed to resolve your issue?

I would be grateful to hear from you or anybody else with suggestions as what to try next.

Siggy

Re: stucking on creating connection in model

Sgandalf — Wed, 27 May 2020 23:50:31 GMT

Hi again,

I have resolved my issue.

For some reason one of my spreadsheets had unexpectedly added MANY additional blank columns!

After deleting these columns my PowerBI refreshed as usual.

I located and resolved the offending spreadsheet using PowerBI's "Transform data" and reviewing the columns for each "Navigation" step in each data source.

Siggy

Re: stucking on creating connection in model

clozano — Thu, 10 Dec 2020 15:28:06 GMT

Thanks Sgandalf for your feedback.

Since I put my measures into a Measure table, my dataset need more time to refresh locally, but it finish succesfully.

But my problem is in the Power BI service, when I publish my dataset into a workspace, just after publishing, it is thinking, like refreshing. And after much more time than usual, it crash.

with this error:

I check all my tab and no one has colum empty, my model was working perfectly before this measured table.

Few days ago, there were a problem with the gateway, but everything had been updated few days ago with the lastest version, so I get stuck there.

the last refresh fail notification

Do somebody has any solution?

thanks in advance,

kind regards

Christophe

Re: stucking on creating connection in model

timmay — Wed, 12 May 2021 23:43:17 GMT

I solved my same issue just FYI for anyone who has tried the above fixes but is still experiencing "Creating connection in model".

I recently moved all my measures into the one measure group and created folers for them. This means that the old measure group was left behind with no measures in it and they were hidden from view.

these measure groups would give and error on refresh (scroll down on refresh and you can see the error).

On going to the model tab in pbi I could see these measure groups without any measures in them. I just deleted these and this resolved the issue!

Re: stucking on creating connection in model

Anonymous — Mon, 27 Sep 2021 14:27:04 GMT

Still no luck after doint that. only difference is mine works and loads but its stopped telling me how many rows are being loaded?

Re: stucking on creating connection in model

tomascardososer — Tue, 28 Sep 2021 14:59:00 GMT

beware of "--comments"

Re: stucking on creating connection in model

Anonymous — Thu, 30 Sep 2021 06:43:03 GMT

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.

Re: stucking on creating connection in model

Faadiz — Wed, 06 Oct 2021 13:11:56 GMT

Hello,

i tried above also + unchecked "Creating Connection in Model" but its not working?

Its after Septmber update.

Please help. Data Loads into Power Query but when i apply the changes, it is stuck.

Fahd,

Re: stucking on creating connection in model

Anonymous — Fri, 08 Oct 2021 17:35:19 GMT

How did you downgrade the version?

Re: stucking on creating connection in model

Anonymous — Wed, 13 Oct 2021 16:24:49 GMT

I am stuck on this as well. Tried following above steps but didn't resolve the issue. I would rather not downgrade my version.

Re: stucking on creating connection in model

Anonymous — Wed, 13 Oct 2021 16:26:54 GMT

Did you ever get this resolved?

Re: stucking on creating connection in model

wcarter — Wed, 13 Oct 2021 17:28:15 GMT

I have this same issue, though I think it is not that the data isn't loading for me but that it only shows the Creating Connection message the entire time it is loading data. It seems like some bug or change has resulted in users no longer seeing the number of rows loaded during a refresh and instead only this mesasge for all tables.

Re: stucking on creating connection in model

Anonymous — Wed, 13 Oct 2021 17:38:12 GMT

Yes I believe you may be right. I got the 'Creating Connection' message and the data was loaded into my model. I then checked my model and the connections were not made. Seems like a bug on the message but didn't keep me from loading in data and the load did not take long

Re: stucking on creating connection in model

MattGell — Fri, 15 Oct 2021 17:04:27 GMT

I have exactly the same issues - on all my Power BI files for a variety of data sources. It just started in September for some reason.

Everything loads but I cant see the progress of x many rows from x , its a real nuiscance as I cant gauage mcuh longer it has to run - unless I set a timer on my phone. Please fix this

Re: stucking on creating connection in model

MattGell — Fri, 15 Oct 2021 17:06:11 GMT

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.