Filtering Not Working on Power BI Desktop Live Connect to SSAS 2017 With Latest Cumulative Update

[alex-potter]

Have a Power BI Desktop Report operating against a live connection to SSAS 2017 Tabular Cube with latest cumulative update installed.  

Filtering against any field on any table results in visuals breaking. Note that it works totally fine in MS Excel 2016.

Pictures below: 

I am able to create tables leveraging relationships and measures correctly between DIMs and FACTs, but as soon as any filter is applied, even if everything is on the same table, the visuals go into error mode.  

Error Details Below:

Feedback Type:
Frown (Error)

Timestamp:
2019-01-11T21:25:28.6451031Z

Local Time:
2019-01-11T13:25:28.6451031-08:00

Session ID:
08590546-6124-48d4-b9e2-eb7c8b51fdae

Release:
December 2018

Product Version:
2.65.5313.841 (18.12) (x86)

Error Message:
An unexpected exception occurred.

OS Version:
Microsoft Windows NT 10.0.17134.0 (x64 en-US)

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

Peak Virtual Memory:
1.38 GB

Private Memory:
388 MB

Peak Working Set:
430 MB

IE Version:
11.523.17134.0

User ID:
1e667c5c-fc76-4f26-8dc2-7ada98c5daf0

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

Telemetry Enabled:
True

AS Live Connection:
True

Performance Trace Logs:
C:\Users\alex-\AppData\Local\Microsoft\Power BI Desktop\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

Enabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
250%

Supported Services:
Power BI

Formulas:

section Section1;

Any help on this would be appreciated.  I worry that it is the SQL 2017 cumulative update that is the issue, but that update is required to process tables with calculated columns in SSAS due to a different bug. 

Alex Potter

[v-yuezhe-msft · Accepted solution]

@alex-potter,

Regading to this issue, I got information internally : 

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,

[v-yuezhe-msft]

@alex-potter,

You apply CU13 to the SSAS instance, right? If so, a similar thread states the same problem in Power BI Desktop, and the issue is related to SSAS instead of Power BI. Please create a case to SSAS team to get support: https://support.microsoft.com/en-us/assistedsupportproducts.

Regards,
Lydia