Filtered visuals connected to ssas tabular model failing to load

[SynergyDWilkins]

I've got a working SSAS 17 tabular model on my PC, which is working fine in SSMS and Excel.

I can connect to the model in PBI, and I can connect visuals to the measures and data items just fine. For clarity, this is all local on my machine, and I'm not using a the remote connector.

However, when I apply a filter to the page, or use a visual to filter the data on screen, the visuals on the page all fail to load.

The only error message shown is: "An unexpected exception occured."

If I used a dashboard that is not using SSAS, the interconnected visuals work just fine. 

Feedback Type:
Frown (Error)

Timestamp:
2019-01-03T19:44:42.4016355Z

Local Time:
2019-01-03T19:44:42.4016355+00:00

Session ID:
b0f21d66-d7e3-4479-b6c1-b4daa55ee4e4

Release:
December 2018

Product Version:
2.65.5313.701 (18.12) (x64)

OS Version:
Microsoft Windows NT 10.0.17763.0 (x64 en-GB)

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

Peak Virtual Memory:
37.9 GB

Private Memory:
328 MB

Peak Working Set:
473 MB

IE Version:
11.195.17763.0

User ID:
a099ccd3-bdf2-4958-bdca-ac4799098c1c

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

Telemetry Enabled:
True

AS Live Connection:
True

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:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
200%

Supported Services:
Power BI

[v-qiuyu-msft]

Hi @SynergyDWilkins,

I guess you already applied CU13 for SQL Server 2017 for your tabular instance. 

The same issue was reported by other user before. To work around the issue you can uninstall CU13 for SQL Server 2017. You need to contact SQL team for help as I mentioned in this same thread: https://community.powerbi.com/t5/Issues/Cannot-display-visual-when-enabling-visual-filter/idi-p/5897...

Best Regards,
Qiuyun Yu 

[SynergyDWilkins]

ah ok, thanks! and thank very much for the very speedy reply! 🙂

[hvetters]

Exact same issue here. Also CU13 - took me a while to figure out what was the cause. Good to read it is being addressed. Thanks.

[v-qiuyu-msft]

Hi all, 

I got information internally this morning: 

FIX (To Customer):

It will be addressed in next 2017 CU. KB4487751 (not published yet).

ETA is mid-late Feb, 2019.

WORKAROUND (temporary):

Roll back /uninstall the CU13 - Microsoft SQL Server 2017 Cumulative Update Package 13 for SQL Server 2017 - KB4466404

Best Regards,
Qiuyun Yu