power bi keeps loading after selecting data source

[Dimakatso]

Hi Please assist

After selecting the data source on power bi desktop, it stays on loading and does not show the end results. What might be the issue. 

power bi keeps on loading

[v-shex-msft]

Hi @Dimakatso,

Is there any advanced operations in your query table? Such as: append, merge, reference query, invoke custom function...

If this is a case, it may cause increase calculation amount(custom steps will loop calculate on each row with reference datasource) and memory spend.

Regards,

Xiaoxin Sheng