01-11-2019 01:29 PM
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.
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:
2.65.5313.841 (18.12) (x86)
An unexpected exception occurred.
Microsoft Windows NT 10.0.17134.0 (x64 en-US)
4.7 or later [Release Number = 461808]
Peak Virtual Memory:
Peak Working Set:
Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
AS Live Connection:
Performance Trace Logs:
C:\Users\alex-\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Disabled Preview Features:
Enabled DirectQuery Options:
Disabled DirectQuery Options:
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.
Lead Visualization Engineer
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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.