Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to connect to Azure folder Containers and files present in the containers dynamically?

Hello Every one,

 

I'm working on a request where the files(.csv's) will be present in a Azure container folders, these folders are created Dynamically in ADF when ever there is any new test case was implemented for the received file. Every time a new folder will be created and a csv file will be droped in that folder, so I need to create a Power BI report on those csv files that are present in the container folder. I tried to look in the forum if there is any way of connecting to the container folder dynamically and ready the files dynamically, but I did not find any thing. Can any one please help me with this scenario? 

 

Thanks,

AB 

Need Help
Show and Tell
  • sergej_og's avatar
    sergej_og
    2 years ago

    Hey Anonymous ,
    I guess you mean azure blob storage (=container folder).
    To access the data you will need the key from your storage account.
    After connecting to the data you can figure out a pattern to update your data on every refresh run.
    Maybe you have a naming pattern? Would be nice in your case.
    Or you grab all csv inside your storage account. You can do this by adjusting PQ code a bit.

    Since I don't know your exatly case it's a bit challenging to figure out your target.

    Regards

4 Replies

  • sergej_og's avatar
    sergej_og
    Icon for Super User rankSuper User
    2 years ago

    Hey Anonymous ,
    I guess you mean azure blob storage (=container folder).
    To access the data you will need the key from your storage account.
    After connecting to the data you can figure out a pattern to update your data on every refresh run.
    Maybe you have a naming pattern? Would be nice in your case.
    Or you grab all csv inside your storage account. You can do this by adjusting PQ code a bit.

    Since I don't know your exatly case it's a bit challenging to figure out your target.

    Regards

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      This is not the correct solution sergej_og that I was looking at. I'm still searching for my result.

      • sergej_og's avatar
        sergej_og
        Icon for Super User rankSuper User
        2 years ago

        Hey Anonymous ,
        as I wrote above "Since I don't know your exatly case it's a bit challenging to figure out your target".
        Try to describe a bit more precise what is your goal.
        Maybe you can share some screens.

        Regards