Thanks to everyone who watched my live stream today! The audience wasn’t big, but it’s a very narrow topic, not of broad interest. Still, I am glad I got a few interesting questions that actually introduced my future topics quite nicely.
Now that Power BI is so popular, it’s becoming more and more common for organisations to migrate their reports from other BI platforms to Power BI. And why not? You’ll be moving to a modern, industry-leading, cloud-native BI platform and probably saving a lot of money in licensing costs too. As a Microsoft employee I wholeheartedly encourage this (obviously!) but it’s not without its pitfalls.
Data migration is an important part of the upgrade process, arguably the most important apart from upgrading the application code. And the more legacy data the customer database has, the more difficult this process is. Usually, when upgrading large in volume data, it would be reasonable to optimize the data. This can be done in the following ways: