cancel
Showing results for 
Search instead for 
Did you mean: 

Filtered visuals connected to ssas tabular model failing to load

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
Status: New
Comments
v-qiuyu-msft
Community Support

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

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

hvetters
New Member

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

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