Forum Discussion
Incomplete Data From MS Access Query into Power BI
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 ...
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.