Forum Discussion
jaryszek
1 year agoSuper User
Power Query Folding breaking query
Hi Guys, I have notied that when i am using path like this within Folder.Files: let
path = Text.Combine("D:\BundleSetsRepositories\cost-mgmt-data1")
in
path everything is working but when ...
- 1 year ago
thanks,
i tried your proposition:let getSource = () => Folder.Files(Text.Combine({Text.Replace(paramLocalRepositoryPath, "/", "\\"), paramRepository}, "\\")), Source = if Environment = "Local" then getSource() else #table({}, {}) in SourceIt still hanging power bi while publishing. It is like it skipping if else statement and triggering dynamic path no matter of it.
I created support case.
Best,
Jacek
lbendlin
1 year agoSuper User
Folder.Files queries do not fold. Only query sources that support some sort of query language like SQL, SOQL, or OData do fold.
Dynamic sources may be rejected by the formula firewall. You need to hide the dynamic part so that the firewall doesn't see it.
https://learn.microsoft.com/en-us/power-query/data-privacy-firewall
- jaryszek1 year agoSuper User
thanks