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.
When Right Clicking a table column with a hierarchy, I recieve the error below ...
JS Error Message:
Cannot read property 'getKeyColumns' of undefined
Error Message:
An error occurred while rendering the report.
Stack Trace:
Microsoft.PowerBI.Client.Windows.JavaScriptException: An error occurred while rendering the report.
TypeError: Cannot read property 'getKeyColumns' of undefined
at getDrillthroughActionsForSection (ms-pbi://pbi.microsoft.com/minerva/scripts/exploreActions.js:153:135)
at DrillthroughService.<anonymous> (ms-pbi://pbi.microsoft.com/minerva/scripts/exploreActions.js:202:30)
at step (ms-pbi://pbi.microsoft.com/minerva/scripts/powerbicommon.js:82:23)
at Object.next (ms-pbi://pbi.microsoft.com/minerva/scripts/powerbicommon.js:35:20)
at fulfilled (ms-pbi://pbi.microsoft.com/minerva/scripts/powerbicommon.js:13:32)
at processQueue (ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:16606:28)
at ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:16622:27
at Scope.$eval (ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:17913:28)
at Scope.$digest (ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:17727:31)
at ms-pbi://pbi.microsoft.com/minerva/scripts/angular.js:17952:26
Solved! Go to Solution.
reviewing other tabs of my report, I found that one of them had an errant field in the "Drill Through" filter.
reviewing other tabs of my report, I found that one of them had an errant field in the "Drill Through" filter.
Thank you for posting this. PBI can be quite flakey, so I had assumed it was a corrupted pbix file, but after reading this post I found the same cause as you identified.
Quick note to Microsoft...it would be useful to trap and report on these errors in a more meaningful way.