Multiple choices people - error in power bi

[Anonymous]

Hello!

I got this problem, when i've choosed several technicians like pic below I get this error in Power BI "1 of the loaded queries contained errors", and the column gets blank. If I change the sharepoint column "Huvudtekniker" Multiple choices to "NO" it works, but then I can only add 1 technician.

[v-xicai]

Hi @Anonymous ,

You may check if the actual data in each column matches the data type of the column. See the similar case: x of the loaded queries contained errors - but viewing errors shows none?.

>>If I change the sharepoint column "Huvudtekniker" Multiple choices to "NO" it works, but then I can only add 1 technician.

From your words, could you please tell us more about your scenario and what did you do before getting this issue in screenshot?

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I only get errors in power query, I dont know what to look for in there:

The issue isnt in the screenshot in the first post, thats what I want it to be like. I want to add several technicians, but when I do that it shows up like this (Screenshot) in power bi power quesry. But if I change the column setting in the sharepoint list to "NO" for Multiple choiches so I can only add 1 technician it works just fine in power bi.

[Anonymous]

Someone who can help me?

[Anonymous]

Still got this problem, help someone?