Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

PowerBI Services -Data source-Azure Data lake 2 Storage

Hi Experts,

We are Consuming Azure Data Lake Gen2 files into PowerBI, while we create Data source on PowerBI services it asks for Servername and Fullpath!

As many users need to use multiple files within folder on Azure container, can we create one connection pointing to folder so diffferent users can consume different files from that folder by using single connection!

Currently it looks like single connection need to be created for each of the file? 

Can somebody provide info here as best practise or how its done at your organization level! As creating single connection for each file will be difficult for maintenance!

Can we create connection for Folder and that can be used by users to consume required files!

Please suggest/help!

Thanks in advance

Need Help
Tips and Tricks

2 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    Hi Anonymous ,

     

    For such data sources like Data source-Azure Data lake 2 Storage , full path is URLs for Data Lake Storage Gen2 have the following pattern:

    https://<accountname>.dfs.core.windows.net/<filesystemname>/<subfolder>


    In addition, the Azure Data Lake Storage Gen2 connector only supports paths with container, and not subfolder or file. The reference is as follows:

    https://<accountname>.dfs.core.windows.net/<container> will work, while 

https://<accountname>.dfs.core.windows.net/<container>/<filename> or 

https://<accountname>.dfs.core.windows.net/<container>/<subfolder> will fail.

     

    The following is a similar solution, I hope it helps you:

    Solved: Configure Power BI Data Gateway to Data Lake Gen 2 - Microsoft Power BI Community


    Best Regards,
    Henry


    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
      5 years ago

      Hi v-henryk-mstf , thanks for reply!

      We are able to create connection successfully, that's not issue!

      issue is for single file , we need to create single connection, so if 10 files used from container then 10 different connection need to be created?
      so my question is this normal or we don't have any option currently but to create single connection for single file or is there any workaround so we can create single connection till container and any file used from that container can use same connection for refreshes!

       

      eg. I have 2 files used from same container name- test

      1st file Path- test/file1

      2nd file path -test/file2

       

      so currently I have to create 2 connections, is there any way so I can create single connection till test/ and that connection can be used to refresh both files as both are in same container!

      thanks

      vineet