Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.