HM74's avatar
HM74
Regular Visitor
9 years ago
Status:
Needs Info

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

 

Dashboards

4 Comments

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    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

  • HM74's avatar
    HM74
    Regular Visitor
    9 years ago

     

    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's avatar
    HM74
    Regular Visitor
    8 years ago

    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

Completed Ideas