In this Power BI Tutorial, Patrick looks at how to load data from a flat file to the data model. This could be a text, csv or excel file with a lot of columns. Don’t just pull it into Power BI. Take time to structure your data in your data model. From flat file to data model is basic concept, but is worth the time to get it right!
Power BI Tutorial | From Flat File To Data Model