AI Insights in Power Query is a great Premium feature in Power BI. An AI Insights Error can occur if you are not fully aware of the settings you need to check. This foxed me for 2+ hours today. So I hope this post helps someone not waste the 2 hours like me. From the… READ MORE
I’ve been using my solution to extract tables from Powerpoint a lot recently. However, I’ve come across some situations where what looks like a table is actually an embedded Excel worksheet. This can be quite useful in Powerpoint as it provides the ability to create subtotals and apply other formulae. You can add these sort of… READ MORE
Seems, Excel charts is an area that till now wasn’t considered in blogs as a target for Power Query application (Get & Transform in Excel 2016). Nevertheless, PQ can replace some VBA solutions and make your workbooks macro-free. In far 2015 my colleague Zoltán Kaszaki-Krsjak shared with me a very good example of how Power… READ MORE
