Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JD0963
Helper I
Helper I

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

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.

4 REPLIES 4
SJim
Frequent Visitor

Hello,

 

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

v-ljerr-msft
Microsoft Employee
Microsoft Employee

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? Smiley Happy

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;

JD0963
Helper I
Helper I

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;

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.