Forum Discussion
Access Import Error
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:
Community ChampionWell, I'm going to take a few guesses here:
powerbi pointing at a different version of the accdb? -> double check this. make sure accdb is not locked in a current application, maybe add another test field to the accdb, save it, reconnect from powerbi
--
the field is present but shifted in order i.e. it's further to the right in the preview picture
--
the field is calculated from a function in Access that powerbi can't deal with.
--
Try and eliminate those and we'll see if there's any progress
I did everything you recommended. I made sure powerbi was pointed at the right file. I added a test field, which showed up in its correct place. I checked to make sure that the field was not there. It still isn't. Since the field I need is a text box, would that be the reason powerbi can't read it? If so, is there a way to get the records from my original field into a new field that simply uses text, not a text box?
