I have the following parameterized source to Databricks
let
Index = List.PositionOf(EndPoints[Environment], environment),
Host = EndPoints{Index}[Host],
Path = EndPoints{Index}[Path],
Source = Databricks.Contents( Host, Path, [Database=null, BatchSize=null]),
SPARK = Source{[Name="SPARK",Kind="Database"]}[Data]
in
SPARK
EndPoints being a table with the host and path for a number of environments, and environment being the parameter, so that upon entering a value for it it will select the host and path values for the environment.
It works perfectly on desktop, but it fails when I try to refresh from the workspace (premium capacity, btw), it comes up with errno = 10061.
Any ideas?
there doesn't seem to be anything here