Forum Discussion

Dianica6's avatar
Dianica6
Frequent Visitor
4 years ago

Failed to resolve name

Hi 

 

Im trying to refresh my power report .All data set comes from Sharepoint. and i get the following message . can you explain what should i do? 

 

 

Failed to resolve name 'ift'. It is not a valid table, variable, or function name. Column 'AuditAuditDetail_LookupId' in Table 'Audit Recommendation Action Details' contains a duplicate value '5484' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

 

Thanks 

 

Need Help

1 Reply

  • jennratten's avatar
    jennratten
    Super User
    4 years ago

    You will need to remove the duplicate values in Power Query from: 

    Column 'AuditAuditDetail_LookupId' in Table 'Audit Recommendation Action Details'

     

    For the reference to 'ift' we need more details.  Please add your scripts so we can see where this is referenced.