Forum Discussion

raja_94's avatar
raja_94
Frequent Visitor
4 years ago
Solved

Dynamic connecting Azure data lake gen2

Hi all,

 

In power bi source connection  there is any feature to pick data dynamically from azure data lake gen2.

 

for example;

i have one folder in datalake  week1,week2,week3.... it's updated like this every week added one file in the same folder 

what i need once we refresh our power bi that new updated file also need to be add in powerbi.

 

other wise is there any altrenative solution for this please suggest us.

 

 

Thanks,

Raja.

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi raja_94 

    The steps of getting data from Azure Data Lake Storage Gen2 seems like getting data from folder. You will get a dialog box show all files in folder and then you can open the file you want. However each time you can get expand one file from your folder.

    For reference: Analyze data in Azure Data Lake Storage Gen2 by using Power BI

    Here I suggest you to use Combine function from you folder if all your files has the same format.

    Then you can refresh your combine table by Refresh. Here I load Week3 in my Folder and I click "Refresh" button in red box then we will load the latest data from Week3 to Power BI.

    For reference: Combine files (binaries) in Power BI Desktop

     

    Best Regards,
    Rico Zhou

     

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

3 Replies

    • raja_94's avatar
      raja_94
      Frequent Visitor
      4 years ago

      it's a weekly process it's not a one time file picking process every week added new data with week number.

       

      now i implemented  power bi dashboard with week1 data next week for same path new file week 2 added automaticlly how can i get week 2 data also for the same existing dashboard is there any way to pick dynamically. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi raja_94 

        The steps of getting data from Azure Data Lake Storage Gen2 seems like getting data from folder. You will get a dialog box show all files in folder and then you can open the file you want. However each time you can get expand one file from your folder.

        For reference: Analyze data in Azure Data Lake Storage Gen2 by using Power BI

        Here I suggest you to use Combine function from you folder if all your files has the same format.

        Then you can refresh your combine table by Refresh. Here I load Week3 in my Folder and I click "Refresh" button in red box then we will load the latest data from Week3 to Power BI.

        For reference: Combine files (binaries) in Power BI Desktop

         

        Best Regards,
        Rico Zhou

         

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