Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

November 2017 Update - Bug when switching Data Connection

Hi Microsoft Admins,

 

I wanted to alert you to a bug in the November update. When a user tries to switch their data connection (for example from the DEV server to PROD) it breaks all the visuals. However, saving and reopening causes the visuals to work again. Please escalate this issue to the product team for a fix. More detail can be found in the community post here: https://community.powerbi.com/t5/Desktop/November-2017-update-cannot-connect-to-data-model/m-p/299810#M132339

 

Thanks,

James

Reports
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi Anonymous,

     

    Please see below response from PG team: 

     

    This is a known issue that we plan to address with a QFE this month. In the meanwhile there is a workaround - after switching the data source settings,save and close the report and reopen it. After reoping the visuals should load correctly. Unfortunately this will have to happen everytime the source is changed in the session. The QFE will resolve the issue altogether.

     

    Best Regards,
    Qiuyun Yu

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi v-qiuyu-msft and Vicky_Song

     

    I installed the update from the 17th (Version: 2.52.4921.682 64-bit (November, 2017)) and confirmed that it fixed issues on my end. Thanks for your help with getting this resolved.

9 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi Anonymous,

     

    The Power BI desktop release a new November version 2.52.4921.581, based on my test in this version, change data source and after apply changes, the visual display fine. Please try to update the desktop to this version and try again. 

     

    Best Regards,
    Qiuyun Yu

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Vicky_Song & v-qiuyu-msft

     

    Unfortunately, the new version did not work. See below for my information:

     

    Feedback Type:
    Frown (Error)

    Timestamp:
    2017-11-13T14:28:56.1998007Z

    Local Time:
    2017-11-13T07:28:56.1998007-07:00

    Session ID:
    1a55626e-131f-4cfb-8a66-7a006f352352

    Release:
    November, 2017

    Product Version:
    2.52.4921.581 (PBIDesktop) (x64)

    Error Message:
    Couldn't retrieve the data for this visual. Please try again later.

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

    CLR Version:
    4.7 or later [Release Number = 460805]

    Peak Virtual Memory:
    3.8 GB

    Private Memory:
    340 MB

    Peak Working Set:
    464 MB

    IE Version:
    11.0.9600.18816

    User ID:
    b36959c1-9d2b-4979-ab8f-73f3c8213e52

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

    Telemetry Enabled:
    True

    AS Live Connection:
    True

    Enabled Preview Features:
    PBI_shapeMapVisualEnabled
    PBI_EnableReportTheme
    PBI_numericSlicerEnabled
    PBI_daxTemplatesEnabled
    PBI_reportBookmarks

    Disabled Preview Features:
    PBI_SpanishLinguisticsEnabled
    CustomConnectors

    Disabled DirectQuery Options:
    PBI_DirectQuery_Unrestricted

    Cloud:
    GlobalCloud

    Activity ID:
    null

    Time:
    Mon Nov 13 2017 07:28:53 GMT-0700 (Mountain Standard Time)

    Client Error Code:
    ServiceErrorToClientError

    Error Details:
    An exception of type System.InvalidOperationException occured.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi v-qiuyu-msft,

     

    I also am getting the issue while using Tabular live connection. Thanks for repoting it!

     

    James

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi Anonymous,

     

    Please see below response from PG team: 

     

    This is a known issue that we plan to address with a QFE this month. In the meanwhile there is a workaround - after switching the data source settings,save and close the report and reopen it. After reoping the visuals should load correctly. Unfortunately this will have to happen everytime the source is changed in the session. The QFE will resolve the issue altogether.

     

    Best Regards,
    Qiuyun Yu

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi v-qiuyu-msft and Vicky_Song

     

    I installed the update from the 17th (Version: 2.52.4921.682 64-bit (November, 2017)) and confirmed that it fixed issues on my end. Thanks for your help with getting this resolved.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi Anonymous,

     

    Thanks for your update. As the issue is solved now, I will close this thread. :smileyhappy: 

     

    Best Regards,
    Qiuyun Yu