Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I am looking for some help with error: 'The key didn't match any rows in the table' while refreshing a dataset. I also don't see the Refresh Preview Button. Can someone advise please? Thanks.
Solved! Go to Solution.
@Anonymous You're probably getting this error because your Power Query query is trying to connect to a table or worksheet or something in your data source that has been deleted or been renamed.
Also, Refresh Preview button is available in Power Query only.
@Anonymous In power query, go to source, in the applied steps sections which is in the right and from there you can change the path.
@Anonymous You're probably getting this error because your Power Query query is trying to connect to a table or worksheet or something in your data source that has been deleted or been renamed.
Also, Refresh Preview button is available in Power Query only.
Thanks for the response Nikhil.
You are right. I chose an incorrect path before the refresh and am unable to get that pop-up to select the path now. Could you let me know how I can get that again to get this working?
Thanks again!
@Anonymous In power query, go to source, in the applied steps sections which is in the right and from there you can change the path.
Hi,
I continue to get this error even though the path is correct. What could be causing this?
Thanks
User | Count |
---|---|
90 | |
84 | |
66 | |
62 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
82 | |
71 |