Chris Webb's BI Blog

Diagnosing Power BI DirectQuery Performance Problems Caused By SQL Queries That Return Large Resultsets

The Execute Direct Query event has a duration of 2.1 seconds – meaning that again there is a gap to be explained, a gap where ...
How-To Geek on MSN

5 everyday actions that Power Query does better than regular Excel tools

Any null values will show as blank cells in the final Excel table. If you'd prefer to fix this within the Power Query Editor, ...