Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

FIles under Azure Container are not visible while connecting to PowerBI(Azure Lake Storage Gen 2)

We have different type of files(xlsx,csv,parquet) in one of the sub folders in our Azure blob storage container(Private).

While connecting to blob using Azure Lake Storage Gen 2 from PowerBI desktop, the folders and subfolders inside the container are visible. Whereas the files inside the folder are not visible.

Did anyone faced this problem? Any suggestions on this?

 

Help is much appreciated.

Thanks in advance for the help.

 

Thanks,

Bhanu_VA

Need Help
Show and Tell

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , Once you load a folder, is it showing the file under that in power query or not?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks amitchandak for reply.

       

      Once I load a folder. No, it's not showing any files under the folder.

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ,

     

    Did you select the CDM Folder View when you connect to Azure Lake Storage Gen 2. Maybe you can try File System View to get the files.

    What is CDM Folder?

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi v-chenwuz-msft ,

      Thanks for the reply.

       

      I had thousands of files in my container. When I use File system view, powerBI doesn't allow me to select the need files for loading into Power Query. Moreover when I use File System View all the files are getting loaded into Power Query(even unnecessary files are getting loaded).

       

      So File System View doesn't work like the CDM. Anyother idea?

       

      Thanks,

      Bhanu_VA