cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alex-potter Regular Visitor
Regular Visitor

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

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: 

State 1.PNGState 2.PNG

 

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

Alex Potter
Lead Visualization Engineer
Luxoft Inc.
1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Filtering Not Working on Power BI Desktop Live Connect to SSAS 2017 With Latest Cumulative Updat

@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,

 

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Moderator v-yuezhe-msft
Moderator

Re: Filtering Not Working on Power BI Desktop Live Connect to SSAS 2017 With Latest Cumulative Updat

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Moderator v-yuezhe-msft
Moderator

Re: Filtering Not Working on Power BI Desktop Live Connect to SSAS 2017 With Latest Cumulative Updat

@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,

 

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.