Forum Discussion

nb02187's avatar
nb02187
New Member
2 years ago
Solved

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

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. 

Need Help
  • edhans's avatar
    edhans
    2 years ago

    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.

1 Reply

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    2 years ago

    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.