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 all,
Is it possible to have the files within a sharepoint folder automatically loaded as separate queries (given that they are all of the same type, csv)?
When I connect to a SQlite db the tables are loaded as separate queries, I was wondering if there is any chance this can be done for the files within a folder as well (instead of selecting one-by-one)?
ps.: I don't want to combine the files into one, all files are of the same type (csv), they have different columns.
Thanks,
Pietro
Solved! Go to Solution.
Hi @Anonymous ,
I don't think there is a way to do it. You could post your ideas about bulk import here to improve Power BI and make this feature coming sooner.
Hi @Anonymous ,
I don't think there is a way to do it. You could post your ideas about bulk import here to improve Power BI and make this feature coming sooner.
Hi @Anonymous
I don't think if you can automate the creation of new objects like queries, do you mind if I ask why would you need this functionality?
Hi @Mariusz ,
Thanks for the reply. I'm passed the raw data in a number of csv files (60+), they are regularly updated, they must be processed individually for the creation of this specific report. If I could connect to the folder and have the queries ready, it would be a just way to save some time, if not possible no worries:)
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.