Unable to load data into model - Stuck on Loading Data into Model

[44GP]

Hi, 

one of our users has tried to load data from multiple data sources into the Desktop app but they all get stuck on 'Loading Data into Model", detals below.....

1. We are on the December version, can't upgrade as we are in a change freeze

2. We have tried a unintaill/install

3. we have tried loading local excel files, sharepoint files and dataflows.  All get stuck.

4. We have removed all the dataload settings as suggested in other posts, but still get the same problem.

Any ideas PBI Community?

Thanks in advance.  

Gary

[coskuersanli]

Hi Gary,

Is it possible to disable all tables and load them one by one?

[44GP]

Hi, thanks for the quick reply.  It gets stuck on one small local excel file.  To try and resolve the issues we have tried a number of different sources with a single small table and no transformations, they all get stuck.

Gary

[coskuersanli]

I had the same problem a while ago. Once you manage to load any table the problem will be solved. Can you disable every table in power query and load a small table. After that you should be able to load the others. 

At least it had worked for me 🙂

[MRB219]

Hi Coskuersanli.
I am the user having issues.
Fresh PIBX file.
Loading Excel Sheet from Desktop.

Still nothing, stuck on "Loading data into model"

[coskuersanli]

Hi @MRB219 

Can you clear cache and try again, please?

[MRB219]

Cleared Cache in all three sections and still unable to load to Model.
Have also cleared out all permissions under Data Source Settings 

Also played around with which drives I was trying to import from as the desktop is my H: Drive, so created a one line spreadhsheet on my C: drive but that also did not allow me to load data to model.

Even a blank table created directly into Power Bi itself with a single line single cell, will not load.

[MichelleLe]

I think I may be experiencing a similar issue - did you manage to resolve?

[Emily123]

Hi Michelle, did you also have to get a fresh profile build? Or did you manage another way to get it sorted?

[MichelleLe]

Hi @Emily123 - it's been a while now, but I think at the time I ended up rolling back to a previous version of PowerBI Desktop and managed to continue my work for some time. I'm up to date with my PBI versions now, and haven't experienced the same issues from those frustrating 2 weeks. Sorry, not the answer you were looking for

[MRB219]

Yes Michelle, issue now resolved, unfortunately you wont like the answer as to resolve the issue we I needed a new laptop with a fresh profile build.