Power BI has problems importing from MS Access

[gfgal]

 the fldemployee_number only exists in tblemployees.  It has associations with the other tables, but that named field only appears in the employees table

[v-robertq-msft]

Hi,

According to the error screenshot you posted, it seems that you met this error when you have done some changes in the Power query and click on the “Close and apply” to apply it to the Power BI. I suggest you to go back to the Power query to simply change the column name of “fldemployee_number” to “fldemployee_number1” to check if the problem can disappear.

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

[gfgal]

while the message does make it appear that it occurred during a query, it actually occurred while importing the three tables (tblemployees -the only table with fldemployee_number, tblsales, & tblcustomer_pos).  The sales and pos tables have foreign keys that form relationships with the employee table, but there is only one field in the entire Access DB with the field fldemployee_number.

[v-robertq-msft]

Hi,

Did your dataset has any other data source imported before you import the data from MS Access? I also suggest you to change the field name of column [fldemployee_number] to import the data again to check if the problem can disappear.

Best Regards,

Community Support Team _Robert Qin

[gfgal]

changed the field name to fldemployeeid.  Same result 

[v-robertq-msft]

Hi, 

If you want to get a solution for this kind of connection problem as soon as possible, I suggest you to open a support ticket to get direct help from the technical support team of Microsoft.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

https://powerbi.microsoft.com/en-us/support/

Thank you very much!

Best Regards,

Community Support Team _Robert Qin