Incomplete Data From MS Access Query into Power BI

Anonymous · ‎02-24-2022

Greetings all.

In PowerBI (Feb 2022 Update) I am trying to link to a query from my own Ms Access database and bring in the data to PowerBI.

The query returns 17,905 lines of data when run in MS Access.

In PowerBI, it returns only 4,768 rows. I have no filters, no data transformation, I just want to see 17,905 rows of data.

I can make a table in Access and then PowerBI sees all 17k rows, but that negates having a dynamic query.

I am new to PowerBI and don't know how to fix this or what to look for.

Thanks for considering my problem.

Anonymous · ‎02-28-2022

Hi @Anonymous ,

Simplifying the query seems to have made PowerBI happy now.

So does optimize queries work to load all your rows ? If so, please kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Hope this helps:

https://community.powerbi.com/t5/Power-Query/How-to-Optimize-Memory-Usage/td-p/57915

Best Regards,
Eyelyn Qin

Anonymous · ‎02-28-2022

Thanks for your reply.

I think my Access query was too complex. It was a union of two other queries, and there were counts and calculated fields... The query worked but PowerBI didn't like it. Simplifying the query seems to have made PowerBI happy now. Thanks.

Ehren · ‎02-25-2022

Hi there. How are you connecting? And can you share the M formula text of your query or queries? (A simple way to get this is to copy the query and paste it into a text editor.)