Forum Discussion

kbecker12's avatar
kbecker12
New Member
7 years ago

Column nulled out with MS Access Query Connection

I imported data from a MS Access query and one column (LEVEL) is null in Power BI.  Another column's values are changed to "Other". There are no null values or "Other" in  for these columns in the MS...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi kbecker12 

I cannot reproduce the same issue.Please check if this post could help.If it is not your case,you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Regards,

edhans's avatar
edhans
Community Champion
7 years ago

Additionally, I would check two things:

  • Repair the Access database and make sure it isn't messed up. Database Tools tab, Compact and Repair.
  • Reinstall the Access Database Engine as I've seen that get messed up before. A reinstall cleans up a lot of stuff.
  • kbecker12's avatar
    kbecker12
    New Member
    7 years ago

    Thank you for the suggestions! I haven't tried to reinstall the Access Database Egnine yet, but the Databae compact and repair had no impact on this issue.