Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All -
I am using the direct query connection to my SSAS cubes. When combining a measure and dimension in any visual (for this case a matrix), I receive an odd error that says : couldn't load data for visual.
Ther error message reads:
Release:
October, 2018
Product Version:
2.63.3272.40262 (18.10) (x64)
Error Message:
Internal error: An unexpected error occurred (file 'pfstringstorekj.cpp', line 1277, function 'PFSFSKJ::LockRecordById').
Any ideas what this means?
Is the problem sloved?
In this scenario, to determine the root cause, you may need to use SQL Server Profiler to monitor your SSAS instance and check the detailed error messages there.
To monitor SSAS instance, please refer to below document:
https://docs.microsoft.com/en-us/sql/analysis-services/instances/use-sql-server-profiler-to-monitor-...
Best Regards
Maggie
update - I found this error is for only one dimension in the cube. This is a linked dimension as most are in the cube with the issues. In the main cube there are no issues with that dimension.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |