Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I developed a Power BI Report using a connection to the Accounts Receivable Cube TESTING server.
When I switched and changed the connection to the PRODUCTION server it throws the
the following error: Expression.Error: the key didn't match any rows in the table.
I have compared the M code to other reports that are connected to the production server and the code "looks" exactly the same. I am trying to avoid having to redo the entire report.
Deleting the "Navigation Step" did not solve the problem. Why is Power BI not connecting correctly to the production server AR cube?
Hi @Randy_Rice
its completely impossible to help you without more details about issue. your data example and Power query code for the source
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |