Acces Database Power Bi Desktop says Table is Empty. Is it authorisation problem?

Hi armvoss ,

Based on your description, if Power BI Desktop shows the table as empty, it could be due to an unsupported data type or a problem with the Access database engine. Since you mentioned that deleting the key imports fine, it appears that the composite key may be causing the problem. You can take the following steps:
Make sure you have the correct version of the Access database engine installed. It should match the version of Power BI Desktop (32-bit or 64-bit). Check that the data types in the Access table are supported by Power BI.
Authorization errors when using the ODBC connector may be related to the permissions of the user account you are using. First, verify that the user account has sufficient privileges to access the Access database file. If you are using an Active Directory account for authentication, make sure that you specify the correct authentication method in the ODBC connection string. Consider creating a separate data source name (DSN) for the Access database with the appropriate permissions.
You can download the latest version of the Access database engine at this link
Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center

Best regards,

Albert He

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