Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Environment: Power BI February 2024
Throughout 2023, our reports accessed the Development workspace of a Deployment Pipeline. This allowed us to make a dataflow change in development, test it in a development report, publish the report to development, and then deploy them all up the chain from dev to test to prod.
Starting around the new December 2023 release, our Desktop reports were getting the error "the key didn't match any rows in the table." Clicking on Navigate's settings, we were only given the choice of the production workspace. Assuming that this might be fixed in a later version, I used production to complete my tasks. However, having just installed the February 2024 release, I continue to see this issue.
Has anyone else experienced this? Do you have suggestions for connecting to our development dataflows?
Solved! Go to Solution.
Problem solved. In Desktop, the Data source settings for Dataflows had been changed to use a service account that only had production access. Changing it to a different account solved the issue.
Problem solved. In Desktop, the Data source settings for Dataflows had been changed to use a service account that only had production access. Changing it to a different account solved the issue.
Hi @RandyPgh ,
You can try this:
Below is the post will help you:
Solved: how to resolve Power BI error - the key didn't mat... - Microsoft Fabric Community
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
71 | |
67 | |
51 | |
39 | |
26 |
User | Count |
---|---|
87 | |
54 | |
45 | |
40 | |
36 |