Power Query Hang

[Syndicate_Admin]

Hi there, 

I'm facing issues with Power BI. I had linked it with an excel sheet that I've created but it constantly hangs despite reducing the data size of the excel file and restarting the system a couple of times. 

I've attached the screenshot for easier reference as well. 

Thanks for the help. 

Regards, 

hrlau 

[Anonymous]

Hi @Anonymous ,

Please try to uncheck the following options and then refresh your data model.

Best Regards,

Stephen Tao

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

[ImkeF]

Hi there, 
to troubleshoot this issue, more information is needed.
Please go to he query editor, copy the query code and paste it here.