One or more tables references a dynamic data source with AzureStorage.DataLake

asdfasdfoijdasf 

When using the AzureStorage.DataLake function in Power Query, the data source is considered dynamic, meaning it cannot be used within custom functions or parameterized queries directly.

However, you can work around this limitation by creating a function that accepts the ADLS path as a parameter and then using the function in your query. Here's how you can do it:

1. Create a new blank query and define your custom function. This function will accept the ADLS path as a parameter and return the data from that path.
   GetDataFromADLS = (ADLSPathToLoadFrom as text) as table =>
   let
   Source = AzureStorage.DataLake(ADLSPathToLoadFrom)
   in
   Source
   
   Create another query where you call the custom function with the desired ADLS path.
   
   let
   ADLSPath = "your/ADLS/path/here",
   Source = GetDataFromADLS(ADLSPath)
   in
   Source
   
   Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
   
   
   

Thanks for your response, johnbasha33. When I save query you suggest (GetDataFromADLS), I still get the message 'One or more tables references a dynamic data source'. What am I doing wrong?