Select Page

Some OData Tips

We were recently building a data model with on-prem Dynamics data mostly using the OData feed (v8.2).  This article only scratches the surface of what is possible with OData (including update/write functions and much more complex queries than those shown… This post...

Insights made easy with Power BI Template Apps

Data is most valuable when it leads to informed action. Making it easier for people to get actionable insights is what Power BI is all about. Now, with Power BI Template Apps, users can immediately begin exploring, learning, and taking action on key data with...

Keeping Up with Azure Changes

Since I started focusing primarily on Microsoft BI/DW/analytics around 2005, I’ve always been happy being a generalist within that space. Fast forward to around 2017 when I started focusing predominantly on Azure. Being a generalist (still within...

Thoughts On The New Power Query Source In SSIS

Yet more evidence that Power Query is taking over the world: there’s a new Power Query data source for SQL Server Integration Services in the latest version of SSDT. Here’s the blog post announcing it (the actual announcement is halfway through): Deeper integration...