Forum Discussion
Scheduling refresh using Azure Data Lake Storage Gen2 connector
Good day forum I am working on a project to pull data directly from from our data lake into Power BI. Using PBI Desktop I am able to make the required connections and retireve desired data. When I...
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.