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 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

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

    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;

  • 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;

  • SJim's avatar
    SJim
    Frequent Visitor
    7 years ago

    Hello,

     

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