Hi everyone,when I try to import my DB into Access on Power Bi, some important tables bring me back this error:index beyond the limits of the matrixI can not understand what it refers to, can someone help me?
By my tests with the Access 2016 and the latest version of Power BI Desktop (2.65.5313.1381), I cannot reproduce your issue.
Do you have any specific setting for your data type or field?
Please have a reference of this case.
If it is convenient, please share your table model here so that I can have a test in my site.
I think the error is due to the "IDFinezze" field that has the "Allow multiple values" setting enabled.
Or that the tables are managed in an access file different from the ones in forms and queries using the "Access Database" function (Database Tools).
You can find the DB at this link: DB to import in Power Bi
Thanks for the support.
By my tests with your DB model, I copy the table tbIAricoli and then I could load the table successfully.
So I'm afraid the issue may be caused by the relationship. As I cannot modify your relationship, you should test by yourself.
In additon, please note you'd better upload the dummy data sample in this community, so if your DB sample is real data, please delete it immediately.
Thanks for the analysis, Cherry.Is it possible to import an access without relations?
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!