Overcoming Date Range Hurdles (Power BI/DAX)

The single biggest challenge when developing a reporting solution is data. Invariably, you won't always have one database that contains all the information you need; often, you will need to bring across disparate and unrelated data sources into a common model. This problem can be exasperated if your organisation has a number of application or [...]

Power BI Deep Dive: Using the Web API to Query Dynamics CRM/365 for Enterprise

I have had an opportunity recently to start getting to grips with the wonderful world of PowerBI. For those who have walked the tightrope between Excel and SQL Server Reporting Service (SSRS) Reports, PowerBI appears to be the tool with these individuals in mind. It enables you to leverage existing Excel knowledge (through PowerQuery or [...]