Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
Fairly new to PowerBI and looking for some help.
I have around 60 excel files structured as follows:
Filename: Apr 20 Sheets: 2017, 2018, 2019, 2020
Filename: Apr 19 Sheets: 2017, 2018, 2019
Filename: Apr 18 Sheets: 2017, 2018
Filename: Apr 17 Sheets: 2017
These are point in time files. So the "Apr 17" file incudes all data for the 2017 year asat 30/04/17. The "Apr 19" file also contains data relating to the 2017 year, but is asat 30/04/19
Here's what i need to do;
Help would be much appreciated.
Thanks
Solved! Go to Solution.
Hi @MrToast20
All of this is possible using Power Query, please refer to this article to give you an example of how to do it
Regards
Phil
Proud to be a Super User!
Hi @MrToast20
All of this is possible using Power Query, please refer to this article to give you an example of how to do it
Regards
Phil
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |