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
I've searched for a few videos and tutorials on the best way to import my data but I am not sure they will work for my quite heavy datasets
I have 12 months of data with each month having roughly 200k rows of data which I need to pull together into Power BI to analyse as I cannot do it in Excel (for obvious reasons 🙂 )
Can anyone explain/guide/point in the right direction of something that can help me with this as I need to pull together an end of year report (for the first time) before the Xmas period starts
Thanks for any help/advice or links
Dan_B
Solved! Go to Solution.
Please visit at below links for your solution:
2.https://powerpivotpro.com/2016/12/import-csv-files-folder-filenames-power-bi/
3. https://www.youtube.com/watch?v=pMQK1Zcc9jw
Don't forget to hit Thumbs up and accept this as a solution if you find it helpful!
I should also mention that the columns are all exactly the same and there are quite a few of them but I could probably trim some of them if it would make the task easier/more manageable in any way
Also, the main column that links them is an entity ID which will have multiple rows as there are multiple responses per entity
Thanks again
Please visit at below links for your solution:
2.https://powerpivotpro.com/2016/12/import-csv-files-folder-filenames-power-bi/
3. https://www.youtube.com/watch?v=pMQK1Zcc9jw
Don't forget to hit Thumbs up and accept this as a solution if you find it helpful!
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |