How to upload drop down fields in an access table into Power Bi?

[nb02187]

Hi, 

I'm new to PowerBi. I was able to get data from our internal Access database. All the columns transfered over, except the fields that are set up as drop down fields. Below is the 3 fields that did not transfer. Is there any tip/tricks to have thes fields in the table transfer?

Below you can see the Part Number Field, DSQR, and Attachements didn't populate. 

Any help would be appreciated. 

[edhans · Accepted solution]

You should create a view in Access that materializes those dropdown fields as true fields in a flattened table, then connect your Power BI semantic model to that new view.