Forum Discussion
PowerBI Could not load data for this visual (connecting to SSAS)
Hi JD0963,
After a few research, I find a similar thread here in which a workaround is mentioned. Could you go to check if it helps in your scenario? :smileyhappy:
After further testing I found the problem. When adding fields which contain blank fields in SSAS the problem occurs.
As a workaround I replaced the blank fields with the text 'Unknown'.
Regards
I am getting this same exact error but on azure sql.
Feedback Type:
Frown (Error)
Timestamp:
2017-12-04T19:07:33.2948241Z
Local Time:
2017-12-04T11:07:33.2948241-08:00
Session ID:
dcb982d9-7ce8-4d4e-8647-95d4416a1694
Release:
November 2017
Product Version:
2.52.4921.682 (PBIDesktop) (x64)
Error Message:
An unexpected error occurred (file 'xmvsquery.cpp', line 3184, function 'XMVSColumn::Bind').
OS Version:
Microsoft Windows NT 10.0.16299.0 (x64 en-US)
CLR Version:
4.7 or later [Release Number = 461308]
Peak Virtual Memory:
33.8 GB
Private Memory:
241 MB
Peak Working Set:
366 MB
IE Version:
11.64.16299.0
User ID:
3c49a3f3-6bc5-412a-ba60-62d324832990
Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Telemetry Enabled:
True
AS Live Connection:
True
Performance Trace Logs:
C:\Users\aadang\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
PBI_daxTemplatesEnabled
CustomConnectors
PBI_reportBookmarks
Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
Cloud:
GlobalCloud
Activity ID:
null
Time:
Mon Dec 04 2017 10:57:18 GMT-0800 (Pacific Standard Time)
Error Code:
QuerySystemError
OData Error Message:
Failed to execute the DAX query.
DPI Scale:
100%
Supported Services:
Power BI
Formulas:
section Section1;