Unable to create Relationship with Lookup field in a SharePoint List

[nickjwhite]

Dear Community,

I hope you can help a complete novice here.

I am trying to create a report in Power BI, relating to SharePoint Lists.

There is a Lookup field in 'Action List' [TaskID] that refers to column [TaskID] in the main Table.  It is a Many to One relationship.

BUT... when I try to create a relationship, the [TaskID] field does not appear in the 'Action List', only [TaskIDId], and this does not contain the same data, therefore the relationship is not working.

I have tried to create a calculated field in the the 'Action List' to create another field containing the contents of the [TaskID], but the formula does not recognise =[TaskID], even though this is the name of the field.  (Double checked by referring to the details after Field= in the URL of the column)

Can anyone help me make this work?

Much appreciated. 🙂

[christinepayton]

I would go into your query and examine the query steps - the TaskID column in your second example does not look like any ID column I've seen coming from SharePoint. It's usually a number column. The second one looks like something else that was renamed TaskID but is not actually the task ID (it looks like it could be the title field perhaps). 

Additionally once you get that sorted out, make sure the column types are the same (both text or both whole number - doesnt matter as long as they match).