cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
raja_94
Frequent Visitor

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.

1 ACCEPTED SOLUTION
RicoZhou
Community Support
Community Support

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.

1.png

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.

2.png

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.

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@raja_94 , check this blog should help.

https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4...

 

As we can read gen2 as a folder similar kind of code should work

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

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. 

RicoZhou
Community Support
Community Support

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.

1.png

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.

2.png

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.

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors