Datatype Conversion in Power Query Affects Data Modeling in Power BI
In my consulting experience working with customers using Power BI, many challenges that Power BI developers face are due to…
Archive
Tag: Data Preparation
Slowly Changing Dimension (SCD) in Power BI, Part 2, Implementing SCD 1
I explained what SCD means in a Business Intelligence solution in my previous post. We also discussed that while we…
Combining X Number of Rows in Power Query for Power BI, Excel and Power Query Online
A while back, I was working on a project involving getting data from Excel files. The Excel files contain the…
Integrating and Visualising Multiple Microsoft To Do Accounts with Power BI
It’s been a while that I use Microsoft To Do to organise my daily tasks. From work-related tasks to buy…