Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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.
Solved! Go to 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingJoin the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.