The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 @Anonymous
its completely impossible to help you without more details about issue. your data example and Power query code for the source