Forum Discussion
Power Query very Slow
In PowerBI Desktop I have (parameter): cdir: C:\Users...\ let fName = "x.xlsx", Source = Excel.Workbook(File.Contents(cDir & fName), null, true), and it hangs forever and ever. The x.xls...
morrtenjansen
I guess this is because you have made many transformation when shaping the data, more steps meaning more calculation, that could take longer time. If you can post the M codes see if we can optimize the calculation.
Paul Zheng _ Community Support Team