Microsoft Access Data I'm trying to import into PowerBI won't show up. Can someone Please help?

[Anonymous]

Hello All,

I'm trying to import an access table into Power BI and the table isn't showing up in the import field in Power BI. I'm not using NZ in the table and I'm using 64 bit versions of Access and PowerBI. Also the table was created from a query I created with IFF statements. Can someone please help?

[v-yetao1-msft]

Hi @Anonymous 

Actually, I don't quite understand what you mean. What is NZ? What are IFF statements? Can you describe your operation and your problem with screenshots or detailed text? Don't you use the Access database connector supported by Desktop itself to connect to the access table?

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.