Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

PowerBI Desktop hanging when running Direct Query models

I am currently using direct query to analyse some information on a Azure Database, basically the query ends really fast but PowerBI continues to show the message "Working on it..." forever... Also a...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi Anonymous,

 

Were you loading large data from Azure Database? Please test whether issue persists if it has less data. 

 

Also, please try below things to troubleshoot this problem.

File -> Options and Settings -> Data Load, uncheck the highlighted options.

 

Use 64 bit Power BI Desktop to connect to your data source.

 

Best regards,
Yuliana Gu