Forum Discussion
Schedule Refresh Error due to Function used in Desktop
Hi Anonymous
Could you show an screenshot of the refresh error message?
Best Regards
Maggie
And here is the code from the table: factOpportunitiesLeaders
let
Source = factOpportunities,
#"Removed Other Columns" = Table.SelectColumns(Source,{"_new_opportunityleader1id_value", "_new_opportunityleader2id_value", "_new_opportunityleader3id_value", "_new_opportunityleader4id_value", "opportunityid"}),
#"Reordered Columns" = Table.ReorderColumns(#"Removed Other Columns",{"opportunityid", "_new_opportunityleader1id_value", "_new_opportunityleader2id_value", "_new_opportunityleader3id_value", "_new_opportunityleader4id_value"}),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Reordered Columns", {"opportunityid"}, "Attribute", "Value"),
#"Removed Columns" = Table.RemoveColumns(#"Unpivoted Other Columns",{"Attribute"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Value", "Leader"}})
in
#"Renamed Columns"