Creating a Power BI data model from a flat file source hosted on SharePoint or Azure Data Lake Store can be cumbersome. I recently found this out trying to create a simple data model for a demo, which involved files sized over 3 gigabytes. Every time I performed a transformation in Power Query and hit Close […]