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 dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 |
---|---|
66 | |
65 | |
56 | |
39 | |
27 |
User | Count |
---|---|
85 | |
59 | |
45 | |
42 | |
39 |