Forum Discussion

mshoka's avatar
mshoka
New Member
3 years ago

Problem with uploading Choice fields from Excel

Hi - I'm a new Dataverse user and am running into an error when using Power Query to load data into Choice fields from an Excel file. More specifically, the error only occurs when I try to upload mu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi mshoka ,

 

Try to uncheck the automatic detection of column data type and headers and load again.

Data types in Power Query - Power Query | Microsoft Docs

Or refer to the following error scenarios, which may be similar to those you are experiencing.

Error handling - Power Query | Microsoft Docs

 

If the above methods do not help, please provide a detailed screenshot of the error, remember to protect the privacy data.

 

 

 

Best Regards,

Stephen Tao

 

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

 

 

mshoka's avatar
mshoka
New Member
3 years ago

Hi Stephen-

 

Thanks for your information. I tried unselecting the column protection and still got an error. Unfotunately, the error scenarios didn't apply.  Attached are screen shots of the data in Power Query and the error screen as you suggested. It's dummy data.

 

Thanks in advance for your assistance!

 

- Max