Forum Discussion
KCinMelbourne
Resolver I
8 years agoFormula.Firewall - Please rebuild this combination error
Hi all, Seeking your assistance on understanding this error. I've read some of the blogs on the error but it doesn't quite make sense to me. I get this error in a large number of my queries ...
KCinMelbourne
Resolver I
8 years agoHi Cherry (v-piga-msft),
I had tried that blog on researching this previously. Here is an example of one my tables that has corrupted on refresh last night despite not having changed any of my parameters.
You'll note that this is referencing a SharePoint file and does not otherwise merge, unless invoking a function causes the same error. This would be a woeful design though considering that invoked function is system generated when you extract data from the file.
Following is the code for reference.
let
Source = SharePoint.Files(P_SharePointLocation, [ApiVersion = 15]),
Custom1 = Table.SelectRows(Source, each Text.StartsWith([Folder Path], P_SharePointProjFcstSubmissions) or Text.StartsWith([Folder Path], P_SharePointProjBudSubmissions)),
#"Invoke Custom Function1" = Table.AddColumn(Custom1, "Transform File from Query1 (4)", each #"Transform File from Query1 (4)"([Content])),
#"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),
#"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File from Query1 (4)"}),
#"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File from Query1 (4)", Table.ColumnNames(#"Transform File from Query1 (4)"(#"Sample File (4)"))),
#"Trimmed Text" = Table.TransformColumns(#"Expanded Table Column1",{{"Resource Name or <new demand>", Text.Trim, type text}}),
#"Replaced Value" = Table.ReplaceValue(#"Trimmed Text",null,0,Replacer.ReplaceValue,{"FTE #(lf)Jan-18", "FTE #(lf)Feb-18", "FTE #(lf)Mar-18", "FTE #(lf)Apr-18", "FTE #(lf)May-18", "FTE #(lf)Jun-18", "FTE #(lf)Jul-18", "FTE #(lf)Aug-18", "FTE #(lf)Sep-18", "FTE #(lf)Oct-18", "FTE #(lf)Nov-18", "FTE #(lf)Dec-18", "Total Days 2018", "FTE #(lf)Jan-19", "FTE #(lf)Feb-19", "FTE #(lf)Mar-19", "FTE #(lf)Apr-19", "FTE #(lf)May-19", "FTE #(lf)Jun-19", "FTE #(lf)Jul-19", "FTE #(lf)Aug-19", "FTE #(lf)Sep-19", "FTE #(lf)Oct-19", "FTE #(lf)Nov-19", "FTE #(lf)Dec-19", "Total Days 2019", "FTE#(lf)2020", "FTE#(lf)2021", "FTE#(lf)2022", "Total Days WoL"})
in
#"Replaced Value"Any alternate suggestions would be very welcome.
Cheers
KC
KCinMelbourne
Resolver I
8 years agoHi v-piga-msft,
Just touching base to see if you might have been able to find any alternate troubleshooting options for this issue.
Cheers
KC