Forum Discussion

awepdn's avatar
awepdn
Regular Visitor
7 years ago
Solved

Select specific files from Azure Blob Storage

Hi,   I am using the Azure Blob Storage connector to connect to my storage account. I need to display data from several CSV files (about 50MB in total) that are hosted in a specific container. Th...
Need Help
  • awepdn's avatar
    awepdn
    7 years ago

    Hi v-danhe-msft,

     

    Thanks for your response.

    I think that is quite a limitation for the Blob Storage Connector at the moment.

    I finally ended up with a workaround saving the source files I need for my report on Azure Data Lake Storage.

    The Power BI Data Lake Storage Store connector fortunately is capable of connecting to a specific file (files) only without importing the entire folder (just paste the complete file url).

sankarsudarsan's avatar
sankarsudarsan
New Member
5 years ago

I had a dynamic folder in blob storage. i tried using the blob storage connector which could not connect to the specific folder. One side effect of not being able to do this for dynamic folders is that Powerbi will not add new files in the folder to the data source. this will give you incorrect data when new data files appear. 

 

I tried Lake storage connecter instead of the blob storage connected to access the specific dynamic folder in azure blob storage. "It Worked".  You can use folder url and the same access key that you used with blob storage.