undefined

Sunitha_123 — Mon, 20 Mar 2023 19:29:19 GMT

Expression.Error: We cannot convert the value "[Function]" to type Function.
Details:
Value=[Function]
Type=[Type]

Table.TransformColumnNames(Table1_Table, each
List.Accumulate(Table.ToRecords(Mapping), _ ,
(state, current)=> Text.Replace(Text.Upper(state),current[BEFORE],current[AFTER]) ))

Privacy Error

Mapping

let
Source = Folder.Files(MapPath),
#"Filtered Hidden Files1" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true),
#"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File (2)", each #"Transform File (2)"([Content])),
#"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),
#"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File (2)"}),
#"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File (2)", Table.ColumnNames(#"Transform File (2)"(#"Sample File (2)"))),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"Source.Name", type text}, {"BEFORE", type text}, {"AFTER", type text}})
in
#"Changed Type"

Data

let
Source = Folder.Files(DataPath),
#"Filtered Hidden Files1" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true),
#"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File (5)", each #"Transform File (5)"([Content])),
#"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),
#"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File (5)"}),
#"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File (5)", Table.ColumnNames(#"Transform File (5)"(#"Sample File (5)")))
in
#"Expanded Table Column1"

Re: undefined

AlienSx — Tue, 21 Mar 2023 08:36:27 GMT

check this out

Re: undefined

Sunitha_123 — Wed, 22 Mar 2023 15:33:38 GMT

Thank you. I know its a firewall issue but i need to maintian the Privacy option. How to overcome the issue retaining 'Privacy'. Please suggest. Tx

Re: undefined

AlienSx — Wed, 22 Mar 2023 15:46:28 GMT

Have no idea, sorry. Just

make sure that the privacy level for both data sources is compatible (Public/Public or Organizational/Organizational)

topic undefined in Power Query

undefined

Re: undefined

Re: undefined

Re: undefined