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.
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?