SharePoint List connection error

[karo]

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

[v-lili6-msft]

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]

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