Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to use an excel file (on sharepoint) with a list of Segment IDs as input to a function in a Dataflow (as per in this video).
All works until I get to the stage where I "Invoke Custom Function", and the column returns an error. I don't know enough to decipher the error unfortunately.
let
Source = SharePoint.Files("https://mycompany.sharepoint.com/sites/CentralMarketingTeam", [ApiVersion = 15]),
#"Filtered rows" = Table.SelectRows(Source, each [Folder Path] = "https://mycompany.sharepoint.com/sites/CentralMarketingTeam/Data Vault/Web Pages and Segments/" and [Name] = "Campaign Web Pages and Segments.xlsx"),
#"Filtered hidden files" = Table.SelectRows(#"Filtered rows", each [Attributes]?[Hidden]? <> true),
#"Invoke custom function" = Table.AddColumn(#"Filtered hidden files", "Transform file", each #"Transform file"([Content])),
#"Renamed columns" = Table.RenameColumns(#"Invoke custom function", {{"Name", "Source.Name"}}),
#"Removed other columns" = Table.SelectColumns(#"Renamed columns", {"Source.Name", "Transform file"}),
#"Expanded table column" = Table.ExpandTableColumn(#"Removed other columns", "Transform file", Table.ColumnNames(#"Transform file"(#"Sample file"))),
#"Changed column type" = Table.TransformColumnTypes(#"Expanded table column", {{"Source.Name", type text}, {"Segment Name", type text}, {"Segment ID", type text}, {"Campaign ID", type text}}),
#"Removed columns" = Table.RemoveColumns(#"Changed column type", {"Source.Name"}),
#"Invoked custom function" = Table.AddColumn(#"Removed columns", "Custom", each GetCampaignSegmentIDs([Segment ID]))
in
#"Invoked custom function"
Solved! Go to Solution.
Hi, @Anonymous
After ensuring that the function is created and called correctly, you also need to check the firewall.
Please refer to this related thread.
Expression.Error: Cannot convert the value "[Function]" to type Function
Best Regards,
Community Support Team _ Eason
Hi, @Anonymous
After ensuring that the function is created and called correctly, you also need to check the firewall.
Please refer to this related thread.
Expression.Error: Cannot convert the value "[Function]" to type Function
Best Regards,
Community Support Team _ Eason
Thanks for your help, looks like I didn't have "Organisational" for all my Data Source Credentials. Updating all the credentials to Organisational fixed this.
Bump
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.