Hangs on Creating connection in model...

[Stairs96]

HELP!  I created and have been successfully using my PBI reports for a few months. Today, I went to refresh my visualizations and am stuck on the below item "Creating connection in model..."  I've waited over an hour for this to finish (usually it takes 10 seconds) and it will not complete.  I rebooted my PC, downloaded the latest version of desktop none of which helped.  I went into my queries and manually refreshed the previews, all of which have succeeded....my updated data is displaying in the queries but it just won't refresh the visualizations.  All of my data is pulled from excel spreadsheets....and I manually refresh it.  How do I get past this issue?

[Leann]

I am encountering the same problems...

I import only one table (17,986,280 rows) from ssas server, but it's stucking in "Creating connection in model" for near half an hour. 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!

[Stairs96 · Accepted solution]

Figured it out on my own...one of my source files went from 6,520KB to 33,000KB for no reason.  Onof the spreadsheets contained within went from 45 columns to just about every column populated with something (even though the columns appeared blank).  Once I deleted the "blank" columns, my file went back to its former size and the refresh succeeded with no issue.