Forum Discussion
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 th...
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.
edhans
Community Champion
Community ChampionYou 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.