Forum Discussion
Power BI Power Query connection to Azure Data Lake Gen2
Hello AndyDDC
for sure there is no way to fold back to a CSV-file. Maybe there are methologies where it would be possible to fold, because another engine could load the csv to a database and accepting some native query.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hello AndyDDC
for sure there is no way to fold back to a CSV-file. Maybe there are methologies where it would be possible to fold, because another engine could load the csv to a database and accepting some native query.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Thanks Jimmy, that makes sense about CSV files.
How about Parquet files? I'm wondering if they are able to have some processing folded?
Hello AndyDDC
sorry but I never heard about Parquet files. When you are loading from files it's always best to start with reducing data in the first steps, because this has an impact on loading time. So filter-steps, remove columns-steps and then group steps first
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
