Forum Discussion

karo's avatar
karo
Advocate V
7 years ago

SharePoint List connection error

Hi,

Maybe someone can help me with a workaround, please. 

I have problem with SharePoint list connection to Power BI due to one column. I am aware that this is "known error" due to column settings: Multiple Selection for People or Group Field. Unfortunately, I cannot remove or modify the SharePoint List, however this "problematic" column is not needed for my reports. There is any way to deselect only this "problematic"column from the import to Power BI to avoid the error? 

Regards,

Karo

Need Help

2 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, karo 

    You may try to fill null values or disable allowing multiple selections, 

    If you still have this issue, you'd better create a support ticket in Power BI Support to get further help.

     

    Best Regards,

    Lin

    • karo's avatar
      karo
      Advocate V
      7 years ago

      Hi v-lili6-msft ,

      Thank you for reply, however I cannot modify the sharepoint list setting due to negative implications for the users. I rather looking for a solution where in the query I will be able to remove this "problematic" columnn from the import to Power BI. 

      Any ideas?

      Regards,

      Karo