Microsoft Lists - data with text from a drop-down option

[Anonymous]

Hello, I am trying to introduce data from my Microsoft Lists but it seems that the algorithm cannot read the data that are in a text format and that they´re coming from the drop-down lists options (comes out as an error).

Is there anyway we can translate this data to numbers so they can be introduced to the tables and charts?

Thank you

[Anonymous]

Hi @Anonymous ,

Please correct me if I misunderstood what you meant.
Do you mean that the Microsoft list you import into Power BI should be in text format but show "error"?

Does it work if you uncheck the box and retry it below?

Best regards.
Community Support Team_Caitlyn

[Anonymous]

Hello @Anonymous ,

I have tried this but it doesn´t seem to work.

What I am trying to say basically is that, I have a microsoft list where I have introduced data and some of this data they are coming from a drop-down list (since Microsoft Lists gives you the option to create drop-downs with pre-determined options to enter). Now, when I am linking the Lists with PowerBI, it seems that the data that are coming from these drop-down pre-determined options, cannot be read by the app and thus theyre are not being introduced and it gives me error or it says "list" but basically doesn´t give me any data -  where it says list, I should have the pre-determined data that had been introduced in the Microsoft List (see pictrure below). Not sure if I could explain it better, I am sorry 

Thank you

Kind Regards

[Anonymous]

@Anonymous 

As I have not heard back from you, I wanted to give you some more details about this issue. 

The following attachment is the list that I am trying to sycronize to PowerBI. As you can see there are two columns that are defined as drop-down list (type, partnering area).  

On the other hand, in the following attachment you can see the result of trying to sycronize these two columns in PowerBI.  As you can see everything else does appear as data but regarding these to columns, instead of having the right text appearing, I only have the text that says [list]. I don´t really undestand what is the problem here and how to solve it.

Let me know

Thank you