cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AndrewTFox Frequent Visitor
Frequent Visitor

Source Access - Index beyond the limits of the matrix

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 matrix
I can not understand what it refers to, can someone help me?

 

Cattura2.JPGCattura.JPG

4 REPLIES 4
Community Support Team
Community Support Team

Re: Source Access - Index beyond the limits of the matrix

Hi @AndrewTFox,

 

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.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AndrewTFox Frequent Visitor
Frequent Visitor

Re: Source Access - Index beyond the limits of the matrix

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.

 

 

 

Community Support Team
Community Support Team

Re: Source Access - Index beyond the limits of the matrix

Hi @AndrewTFox,

 

By my tests with your DB model, I copy the table tbIAricoli and then I could load the table successfully.

 

Capture.PNG

 

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.

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AndrewTFox Frequent Visitor
Frequent Visitor

Re: Source Access - Index beyond the limits of the matrix

Thanks for the analysis, Cherry.
Is it possible to import an access without relations?

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors