Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
I'm trying to import a query created in Microsoft Access into Power BI, but I get the following error message when trying to do so: Expression.Error: The key did not match any rows in the table.
I'm sitting on a local computer and all the files that are connected to the Access query are also local. It worked just fine before, but it seems that the error started ocurring after I installed the Power BI October update.
Does anyone have a possible solution for this? I've tried creating the query from scratch again in Access, but I keep getting the same error message.
Solved! Go to Solution.
This seems Bogus I Got the Same - when I clicked Refresh Preview the Table Appeared ! as if by Magic
This seems Bogus I Got the Same - when I clicked Refresh Preview the Table Appeared ! as if by Magic
I'm getting this same error on a view that i copied in. I cleared the cache through the options menu but that didnt help. Basically all my views that i added after i linked to the db are giving me this error. Any suggestions?
Thanks daverpitts, that quick fix works when that same error reading pop's up when pulling a sharepoint list.