DirectQuery: Checking generated SQL queries
If you are working with DirectQuery, Dual-mode or hybrid tables you will inevitably hit your back-end server with loads of queries, some more performant than others. Being able to analyze what queries are sent out comes quite handy - and doing so is quite simple.
Near Real-Time Data Export from Business Central
Every day, Every minute, Fresh data from Business Central. Cloud-enabled near real-time data export—Isn’t that the dream?! I recently discovered an amazing open-source extension for Business Central that let us seamlessly synchronize our data to an Azure Data Lake.
Upskilling from Power BI to Synapse? 🏋️♀️
I’m often asked about how to transition from Power BI to Synapse—Here’s my simple 7 step guide to do just that.
Measure/Column dependencies in Power BI
Wouldn’t it be nice if we could just point at a column and know about any measure that would crash if we messed with it? Yes, it would—it would be a godsend, and we can do exactly that!
Power BI Data Marts
Data Marts are here. It’s still a very new feature. But stay tuned! This blog post will be updated on the fly for the next few days.
PowerPoint high-res export
By default, PowerPoint will only let you export a 96 DPI image file from your slide - but with a bit of tweaking, we can adjust it to just the right resolution.