How to Combine Files in Power BI Using Power Query
You can combine files in Power BI by using the 'Get Data' > 'Folder' option and the 'Combine & Transform Data' feature in Power Query. This approach saves you significant time and effort. For example, loading one million rows with Fast Data Load enabled can be eight seconds faster, and optimizing merges can reduce refresh times from over 30 minutes to j…
Keep reading with a 7-day free trial
Subscribe to M365 Show - Microsoft 365 Digital Workplace Daily to keep reading this post and get 7 days of free access to the full post archives.