Hi all,some time we need to update value in a table in some pattern or increment order. then we use loop and iterate with all record, but as know looping is take time and our application become slower ...

As of the November update of Power Query, it’s now possible to write your own SQL query when you’re moving data out of SQL Server into Excel using Power Query. So I got thinking… if you can write your ...