Forum Discussion
Loading of Data
After merging two tables, in power query when i try to load that data into powerBI, it keeps on loading and get stuck at this particular point, after which neither it get's completed nor it shows any...
I would add a Table.Distinct/Remove Duplicates step to that Excel file's merge column, so that Power Query knows that it's a distinct column. It may already be distinct, but if you specifically enumerate that fact to PQ, it'll probably be much, much faster.
--Nate