“Editing Report/Spreadsheet Mashups in VSCode” - Ilgar Zarbaliyev's Nuzzel Newsletter for Sat, Jul 18

Data Mashup Cmdlets import and export Power Query from most Microsoft Power BI and Microsoft Excel files; however, they don't include a GUI editor. Microsoft's new Power Query / M Language extension for Visual Studio Code provides a graphical…

The pandemic lockdowns put in place to fight the spread of the coronavirus have accelerated the already growing trend of holding virtual meetings. Millions of remote meetings and online interactions have provided Microsoft plenty of data to uncover…

Recently, I have been working on a new report for my supervisor. One of my requirements was to find a total of Service Requests based on what month(s) the user selects on the slicer. I thought this would be an easy task, but it led to some…

Stream graph or stream plot is a variation of area chart that looks like a stream. Here is a quick demo of a stream chart. Learn how to create such a graph in this page. Stream graphs have been around for many years. But this particular graph…

I was doing some work for a customer this week – they had a performance issue with a Power BI report. The data in the workbook wasn't overly large, about 400,000 rows, yet the file size was 110 megabytes and the performance of the model was…