Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.