Forum Discussion
Scheduling refresh using Azure Data Lake Storage Gen2 connector
You should be able to connect at the container level, and then in the first step in Power Query then filter it to the folder level. That should be really quick?
GilbertQ
That is what I am trying now. I have the source to container and then applying a filter to the Folder Path field. The filter being applied is a "begins with" due to me needing files from subfolders under the main folder.
The issue I feel is we are querying every file in the container and there are a lot. In PBI desktop connecting directly to the folder was very quick. I need a way to do the same but while in the service so we can set up refresh.
What happens if you try and use the SAS Token?
I have successfully used the container name (storage name) in Power BI and successfully refreshed the data quickly.