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.
I have nearly 2000 csvs in one folder. I want to load them all into my PowerBI desktop and:
However when I clicked the load from folder button, it gave me the following:
looks like it doesn't actually load the csv at all. Any way to force the software to load them all as 1k plus tables or can I just add a column which stores the real csv data and access the "nested column" inside this newly created column?
Solved! Go to Solution.
Hi @AbelNewton
You can do it in three loads.
For each type of file, filter your table with (example Balance_Sheet), next click on two arrows in Content Column, this will expand all the files in to one table.
Repit this for all the file types.
@Mariusz To be honest, there are three kinds of structres: balance sheet, income statement and cash flow. I just want load them in bulk and deal with all of these later. Writing programs if needed is not a big issue for me.
Hi @AbelNewton
You can do it in three loads.
For each type of file, filter your table with (example Balance_Sheet), next click on two arrows in Content Column, this will expand all the files in to one table.
Repit this for all the file types.
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |