Visualizations don't work after migrating SSAS model from 2012 to 2017

[Anonymous]

I built a SSAS 2017 to replace our 2012. I re-deployed a model to the new 2017 instance at compatibility 1200, and also another one after upgrading the model to 1400. They both deploy successfully.

I am using Power BI Desktop (Optimized for Report Server) Jan 2019 build.

If I open an EXISTING Power BI file that works against our current SSAS 2012, and point it to either the 1200 model or 1400 model on the new 2017 instance, visualizations won't work. I get "Can't display the visual". When I click "details", I get "Couldn't load data for this visual An unexpected exception occurred", along with the details below. Is there something I'm missing? Everything seems identical. Something I need to change within the Power BI file other than just re-pointing to the new data source?

Feedback Type:
Frown (Error)

Timestamp:
2019-02-28T15:27:34.3457559Z

Local Time:
2019-02-28T10:27:34.3457559-05:00

Session ID:
6dd75803-9ecb-4332-a2bc-0da4530d43e7

Release:
January, 2019

Product Version:
2.65.5313.1421 (18.12) (x64)

Error Message:
An unexpected exception occurred.

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

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

Peak Virtual Memory:
3.84 GB

Private Memory:
469 MB

Peak Working Set:
572 MB

IE Version:
11.0.9600.19266

User ID:
3dd523cf-a467-4b56-bcc4-3ebd5465b3f4

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

Telemetry Enabled:
False

AS Live Connection:
True

Performance Trace Logs:
C:\Users\XXXXXXX\AppData\Local\Microsoft\Power BI Desktop SSRS\PerformanceTraces.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
MIntellisense
PBI_SpanishLinguisticsEnabled
PBI_PdfImport
PBI_ColumnProfiling
PBI_variationUIChange
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_FuzzyMatching
PBI_EnableWebDiagramView
PBI_improvedFilterExperience
PBI_qnaLiveConnect

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI Report Server, Power BI

Formulas:

section Section1;

[Anonymous]

I should also point out that if I create a NEW file in Power BI Desktop and point it to the 2017 instance, visualizations work fine.

[v-yuezhe-msft]

@Anonymous ,

Do you install CU13 for SSAS 2017? Do you create any DAX and apply any filters in your visuals?

Currenly, there is an issue with SSAS 2017 CU13 as described in this KB.

Regards,
Lydia

[Anonymous]

Yes, CU13 is installed, and I bet I am affected by this DAX issue.

Based on the new "Modern Servicing Model", and the statement "Starting with SQL Server 2017 CU13,   CUs will be delivered bi-monthly (every other month) instead of quarterly.", I'm assuming we'll see CU14 very soon. I'll wait for that instead of trying to uninstall CU13.

Thank you!

[Anonymous]

[SOLVED] I can confirm that SQL Server 2017 CU 14 solved this problem in my environment. Visualizations are now showing properly!