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...
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.

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.