November 2017 Update - Bug when switching Data Connection

[Anonymous]

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/29981...

Thanks,

James

[v-qiuyu-msft · Accepted solution]

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

[v-qiuyu-msft]

Hi @Anonymous,

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

Best Regards,
Qiuyun Yu

[Anonymous · Accepted solution]

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 · Accepted solution]

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]

Hi @v-qiuyu-msft,

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

James

[v-qiuyu-msft]

Hi @Anonymous,

Which data source do you get data from? I reproduce the issue with SSAS tabular live connection and already reported it internally: http://community.powerbi.com/t5/Issues/SSAS-tabular-model-switch-issue/idi-p/302132

Best Regards,
Qiuyun Yu

[Anonymous]

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.

[v-qiuyu-msft]

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