One of the biggest benefits of Power BI is the ability to import data from multiple sources quickly and easily. But sometimes the data is in an unfamiliar or incompatible format for our settings.
In this video, we’ll learn how to solve this problem in Power Query without much effort at all, and allow different datasets to have different import formats without causing the model any issue.