Forum Discussion

schwibach's avatar
schwibach
Frequent Visitor
4 years ago

Import SharePoint Online List RealFieldName Expression.Error

Hello,

 

Im rather new to PowerBi and am trying to import a SharePoint Online List.

 

When I do, I get the following error:

It says that the unique criteria are invalid.

Has anybody ever encountered this and knows how to fix it.

Here are the columns I have in that list.

Also, the title is not unique.

 

 

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Looks like you removed the default primary key / ID column from your list?

     

    Try with a fresh list.

  • schwibach's avatar
    schwibach
    Frequent Visitor
    4 years ago

    Thanks for the replies.

    The ID column is still in the list. I haven't removed it.