PowerBI Could not load data for this visual (connecting to SSAS)

[JD0963]

Hello, hoping one of you experts could help me!

I am new to PowerBI and have created a Tabular Model in SSAS. This Model sources its data from live tables on SQL server. It is also not running in direct query mode.

I haven't deployed it yet, so I am accessing it in PowerBI with the localserver. Now I have created some visuals that seem to work fine, however others keep throwing the following error message

"Couldn't load data for this visual. An unexpected error occured (file xmvsquery.cpp, line 3193, function XMVSColumn::bind)

which only seems to resolve when I re-process the data in SSAS. And then a few seconds later the error happens again when I select refresh on the PowerBI side.

[SJim]

Hello,

I encounter the same problem, did you ever find a solution for this?? @JD0963 

[v-ljerr-msft]

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? 

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

[aadang]

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;

[JD0963]

Also, this is the error I am getting..

Feedback Type:
Frown (Error)

Timestamp:
2017-11-24T10:35:58.1859057Z

Local Time:
2017-11-24T10:35:58.1859057+00:00

Session ID:
a003c9df-6bfe-4340-b31c-0fe6c2bc1c74

Release:
November 2017

Product Version:
2.52.4921.682 (PBIDesktop) (x64)

Error Message:
An unexpected exception occurred.

OS Version:
Microsoft Windows NT 10.0.15063.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 460798]

Peak Virtual Memory:
33.8 GB

Private Memory:
266 MB

Peak Working Set:
379 MB

IE Version:
11.674.15063.0

User ID:
664fedbc-b6b3-4f5c-8ed0-12028a7a0ce6

Workbook Package Info:
1* - en-GB, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

AS Live Connection:
True

Performance Trace Logs:
C:\Users\Jordan.Dwyer\AppData\Local\Microsoft\Power BI Desktop\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:
Fri Nov 24 2017 10:35:49 GMT+0000 (GMT Standard Time)

Error Code:
QuerySystemError

OData Error Message:
Failed to execute the DAX query.

DPI Scale:
100%

Supported Services:
Power BI

Formulas:

section Section1;