Forum Discussion

JD0963's avatar
JD0963
Icon for Helper I rankHelper I
8 years ago

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...
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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

  • aadang's avatar
    aadang
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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;