Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Schedule Refresh Error due to Function used in Desktop

Hi PBI gurus!   Greatly appreciate any help or guidance on this issue. We are using a Function (fGetDuration) from another table in our data model. All tables come from the same sql database (Pract...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous

Could you show an screenshot of the refresh error message?

 

Best Regards

Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

     

    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"

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Maggie v-juanli-msft

     

    Just wanted to check to see if you have had a chance to look into this issue. Let me know if you need more information than what I provided with the code above. 

     

    Thanks so much!

    Katie