Power query editor

[AtchayaP]

I have tried to take dataset from dataflow and spreadsheet , I have created with dimension table.

But it's taking time to load the data from fact table.what is the way to do?

 you can see the yellow dot,  when I'm trying to click fact table in power query editor it is taking more than 2hrs to load. Please try to give solution anyone..

@parry2k 

[artemus]

The slowness can largely be due to your data set size and source kind... if possible try to do your steps using a smaller sample dataset, and change it to the full one when you are done.

Also this may be waiting for other steps to calculate if you recently made a change to an ealier step.