Forum Discussion

mvillebbaughman's avatar
mvillebbaughman
New Member
4 years ago
Solved

Access Import Error

I have been trying to import an Access database into Power Query, but it is consistently not importing one of the fields, which happens to be one of the more important fields needed for the report. I...
Need Help
HotChilli's avatar
HotChilli
Community Champion
4 years ago

Good troubleshooting.

The 'text box' or 'dropdown' will be a feature of the interface.  The Access db will store it in a particular Access datatype.  Maybe you could investigate this.  It will be viewable in a Properties section of the table in Access.

I am leaning towards a function being used in Access.

See this thread:

https://community.powerbi.com/t5/Desktop/Missing-MS-Access-tables-queries-in-the-Navigator/m-p/106506/highlight/true#M44660 

  • mvillebbaughman's avatar
    mvillebbaughman
    New Member
    4 years ago

    I was able to get all the data copied into a new field that was able to be imported into Power BI. Thanks for the help. I'll mark this as answered.