In the 3rd video of the Power BI Series I show you how to load multiple files into Power BI using the Query Editor and to troubleshooting a Date type Error.
In this video we covered:
– How to load multiple excel files to Power BI
– How to use Append Query to create a unique dataset
– Date error- Use locale
– Regional Settings
Keep tuned for the next video and learn How to Create Measures and Calculated Columns
You can download the files here:
And access the online dashboard here