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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Can't display the visual when adding dimensions fields from SSAS

 

Hello,

 

I have a problem when adding certain fields to the visuals in PowerBI. => 'Can't display the visual.' 

We connect to SSAS (live) and this error occurs on dragging certain dimension fields (System.String) to the visuals. The strange thing is large fields (2000 char.) and small fields (1 char.) are no problem but fields with for example 50 char or 100 char fail.

 

Thank you

 

Capture PowerBI.JPG

Status: Needs Info
Comments
v-haibl-msft
Microsoft Employee

@HM74

 

Are you using the latest version 2.48.4792.721 (July 2017) of Power BI Desktop? What is the detailed error message after you click See details?

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
HM74
Regular Visitor

 

Hello,

 

The version is : 2.47.4766.581 64-bit (juni 2017). Optimized for use with Power BI Report Server. This is the latest version for Report Server.

 

The error is 'Internal error: An unexpected exception occurred.' You can find the details below

 

Feedback Type:
Frown (Error)

Timestamp:
2017-07-13T10:52:56.9613265Z

Local Time:
2017-07-13T12:52:56.9613265+02:00

Product Version:
2.47.4766.581 (PBIDesktop) (x64)

Release:
June, 2017

IE Version:
11.0.9600.18665

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)

CLR Version:
4.6.1 or later [Release Number = 394271]

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

Peak Working Set:
420 MB

Private Memory:
313 MB

Peak Virtual Memory:
3.79 GB

Error Message:
Internal error: An unexpected exception occurred.

User ID:
21aa53d9-306d-479c-abd5-d11fe29bc08c

Session ID:
df6d368e-3b67-4f33-a7e9-f00b2419a896

Telemetry Enabled:
True

AS Live Connection:
True

Performance Trace Logs:
C:\Users\hartmaes.BRUSTJAN\AppData\Local\Microsoft\Power BI Desktop SSRS\PerformanceTraces.zip

Disabled Preview Features:
PBI_Snowflake
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_allowBiDiCrossFilterInDirectQuery
PBI_pivotTableVisualEnabled
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
PBI_PbiServiceLiveConnect
PBI_daxTemplatesEnabled
PBI_relativeDateSlicer
CustomConnectors

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Cloud:
GlobalCloud

Time:
Wed Jul 12 2017 08:12:21 GMT+0200 (Romance Daylight Time)

Error Code:
QuerySystemError

OData Error Message:
Failed to execute the DAX query.

DPI Scale:
100%

Supported Services:
Power BI Report Server,  Power BI

Formulas:


section Section1;

HM74
Regular Visitor

Hello,

 

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,

Hartwig