Forum Discussion
How to import .csv file from blob storage folder
I have a folder in blob storage with multiple files. every day there is generated .csv file with diferent name.
How can I import it to power bi: a file from specific blob storage container with .csv extension?
I cannot attache to file URL because every day all files from this container are deleted and created new one, therefore the name of file and url changes every day. I need to take only by .csv extension
Hi , Anonymous
According to your description, you want to connect to the .csv in your blob storage and you do not want to use the file URL.
The only possible way for your needs is to modify the M code of Power Query Editor.
You can check the steps in your Power Query, you can use Text Filter to filter the corresponding .csv file and then connect, and check whether you can use the name you want to use to get the file content.Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
- v-yueyunzh-msft
Community Support
Hi , Anonymous
According to your description, you want to connect to the .csv in your blob storage and you do not want to use the file URL.
The only possible way for your needs is to modify the M code of Power Query Editor.
You can check the steps in your Power Query, you can use Text Filter to filter the corresponding .csv file and then connect, and check whether you can use the name you want to use to get the file content.Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly