Forum Discussion

bimchahaha's avatar
bimchahaha
Microsoft Employee
5 years ago

Power BI dataset dynamic load csv from ADLS Gen 2

I have some csv files in a container folder 

Source = AzureStorage.DataLake("https://*******************.dfs.core.windows.net/*****/csvtable01"),

 

 

under csvtable01 the stucture is yyyy/MM/dd/*.csv 

 

so how to dynamic load the current date folder , when ever the dataset is upload to power bi service .?

 

May I also know if I publich the dataset , and after that, I config the dataset need to use power bi on-prem gateway , and the next time I use power bi desktop to publish the dataset again, will it still using on-prem gateway ?

Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi bimchahaha ,

    You can refer this simliar issue about how to loading the latest file into power bi:

    Only load latest csv files in folder 

     

    "May I also know if I publich the dataset , and after that, I config the dataset need to use power bi on-prem gateway , and the next time I use power bi desktop to publish the dataset again, will it still using on-prem gateway ?"

     

    The next time you publish the dataset, it will still use on-premiss gateway if the dataset name is not changed. 

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.