Power BI refresh gets stuck on the same file

[Anonymous]

Hi,

the data source of my report is a folder with excel files :

and the refresh always gets stuck for hours when loading the Morocco_sep_dec_2018 file after loading 15.9 MB:

I already disabled auto relationship detection nd the parallel loading for tables but it didn't help.

Thanks,

[v-yuta-msft]

@Anonymous ,

Turn the option "Auto date/time" to be off and check again:

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

It was already off 😞

[Tahreem24]

@Anonymous ,

Try to refresh one file at a time.  Like go to Excel file just next to Visualization pane in Desktop and then right on 3 dots and click Refresh data. Likewise, refresh all files one by one.

Don't forget to give thumbs up 👍and accept this as a solution if it helped you.

[Anonymous]

Yes, I tried to refresh only the query called Morocco KPI but I have the same problem.