Refresh stuck on "Creating connection in model..."

[mimiles]

My source files are all .xlsx stored in SharePoint Online. When I try to refresh my Power BI file, all the tables reach "Creating connection in model..." but stay in that state and don't actually refresh. All the source URLs are accurate -- any ideas?

[Evogelpohl]

Same problem.  "Creating connection in model" <- spins forever, never finishes.

Here's my pattern:

-> Source Azure.Blob (5 CSVs)

-> Expand all binaries (works fine)

-> Unpivot Cols (sort out empty cols)

-> Return table (all works fine in edit mode, previews just fine)

...click Apply & PowerBI just spins @ "creating connection in model" forever.  

On the latest version of PowerBI (June '18).

Thoughts?

[rorromartins]

I'm having the same issue and couldn't solve it! https://community.powerbi.com/t5/Desktop/Stuck-on-quot-ceating-connection-in-model-quot-while-trying...

[Anonymous]

Hi @mimiles,

Based on your description, this issue seems related to connection, can you provide some detail content of this issue?
E.g. detail power query formula, connection steps, excel file structure, sample file...

In addition, you can try to test with below methods.

1. Re-create a new report with original file. (Report issue)
2. Change the signed in sharepoint organization account and test again. (Account issue)
3. Test to direct get data from same excel file at local. (data source issue)

Regards,

Xiaoxin Sheng