Select Page

Fast Track Power BI Dev With SharePoint Files

I’m always looking for more productive ways to work with Power BI and associated tools. As I covered in my article last week, development of Power BI reports using SharePoint for your file storage can be so slow that it is impractical. In this article I discuss the...

Power BI and SharePoint – Terrible Together

Until recently, I had not spent a lot of time building Power BI Reporting solutions that have SharePoint Online as a data source (This article refers to SharePoint Online specifically, but I am sure the experience is the same with on premise SharePoint). Over the last...

How I Manage My Day with Microsoft ToDo

This is an off topic post for me (ie not Power BI), but then again – who doesn’t want to be more productive, right? I am a heavily process driven person and I like to organise and plan my days, weeks and months so I can be as productive as […]Read More » This...

Power BI Podcast – Wait, What?!

I have to admit, I never thought that a Power BI Podcast could be a thing, let alone a valuable thing. After all, Power BI is a very visual and interactive tool. But indeed, Power BI Podcast IS a thing invented by my friend and Microsoft MVP Lars Schreiber from...

Dynamic Formatting of Switch Measures

History of Switch Measures Using a switch measure to toggle results is a mature and common technique used in Power BI and Power Pivot for Excel. For example, a switch measure can be used to toggle what appears on a chart so that the end user can easily switch the...

Fixing Incorrect Data in Power BI

One of the features of Power BI (and Power Pivot) is that data cannot be changed once it is loaded into the database – this is by design. Power BI is a reporting database, it is not a spreadsheet.  Power Pivot and Power BI are built to faithfully report on...