Dataset will not refresh

I have a simple Dataset that contains 2 tables. one table has a list of all my databases and the other is a dynamic function (see code below). I Invoke a custom function on database single column table. I assign the single column to my "DatabaseText" variable and everything works great. BUT

When I publish this to the service and try to schedule a refresh I get this error "This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. " I believe you can use "[Relative path" to get around this but I don't know how. Can someone help me? If you can't use "Relative Path", then is there another solution. The power query is looping through every database and providing me all the dependencies. See my power query code below:

= (DatabaseText as text) =>

let
Source = Sql.Database("az-pdwsqls01", DatabaseText, [Query="SELECT OBJECT_NAME(referencing_id) AS referencing_entity_name, #(lf) o.type_desc AS referencing_desciption, #(lf) COALESCE(COL_NAME(referencing_id, referencing_minor_id), '(n/a)') AS referencing_minor_id,#(lf)#(tab)s.name COLLATE DATABASE_DEFAULT aS schema_name,#(lf)#(tab)t.name COLLATE DATABASE_DEFAULT as view_name,#(lf) referencing_class_desc, referenced_class_desc, #(lf) referenced_server_name, referenced_database_name, referenced_schema_name, #(lf) referenced_entity_name, #(lf) COALESCE(COL_NAME(referenced_id, referenced_minor_id), '(n/a)') AS referenced_column_name, #(lf) is_caller_dependent, is_ambiguous #(lf)FROM sys.sql_expression_dependencies AS sed #(lf)LEFT JOIN sys.objects AS o ON sed.referencing_id = o.object_id#(lf)Left JOIN sys.views t#(lf)ON t.[object_id] = sed.referencing_id#(lf)LEFT JOIN sys.schemas s#(lf)on s.schema_id = t.schema_id"]),
#"Added Custom" = Table.AddColumn(Source, "Reference Database and Table Name", each [referenced_database_name] & "." & [referenced_entity_name]),
#"Changed Type" = Table.TransformColumnTypes(#"Added Custom",{{"Reference Database and Table Name", type text}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([referenced_entity_name] <> null)),
#"Renamed Columns" = Table.RenameColumns(#"Filtered Rows",{{"referenced_database_name", "REF Database Name"}, {"referenced_schema_name", "REF Schema Name"}, {"referenced_entity_name", "REF Object"}})
in
#"Renamed Columns"