Forum Discussion
Import all CSV files from folder with different schemas
Hi caninetiger
Currently Power Query doesn't support to create more queries(tables) automatically or dynamically from a table. So this is not possible at present. I read your discussion in another thread about this and you may decide to use a Python script to write them into an Excel Workbook or a database. This seems the best alternative currently.
But I'd like to remind that if these files have too many rows, it may hit the data size limit as you will have 300+ tables in a semantic model. You may refer to Power BI limit for number of tables - Microsoft Fabric Community There is no document to point out that the limit for number of tables in Power BI but there is limit to data size.
Best Regards,
Jing
Greg_Deckler, please excuse my inexperience but I searched through it and I'm not sure where the solution is.
I see your recommendation at the bottom and I've previously looked into writing a specialized function that perhaps could separate all the files in the folder into separate tables but I'm not familiar enough with the M language to do that. I've gotten only as far as listing all the files as separate tables in Power Query (see pic below), but I wouldn't know what to do next:
caninetiger I would recommend reaching out to the user that originally posted the issue and/or ImkeF