SSAS KPI not working in Power BI (or Excel)

[anthonya]

Hi All,

We have a tabular model that has been built in Analysis Services 2016  (13.0.4466.4) and our Power BI reports connect to this data model for reporting

I have created a 2 measures that relate to the issue I am having

Gross Sales

Gross Sales Target

Both of these measure work perfectly fine at sit within a disconnected table called '#Measures'

Within SSAS I created a KPI on Gross Sales as the below picture

After deploying the model evrything works fine and Power BI (and Excel) can use the KPI Status as normal

However the following day when I check on the report it shows the Visual as broken with the following error message.  If I open the KPI in SSAS and then click ok and deploy again, it will work for another period. 

Error Message:
MdxScript(MODEL) (37, 39) Calculation error in measure '#Measures'[_Gross Sales Goal]: Cannot find table ''''''''''''''''''''''''''''''''''''''''''#Measures''''''''''''''''''''''''''''''''''''''''''.

The full error log is below

Any ideas?

Thanks

Anthony

Feedback Type:
Frown (Error)

Timestamp:
2019-08-05T04:34:02.5347577Z

Local Time:
2019-08-05T12:34:02.5347577+08:00

Session ID:
3c2b7f47-507f-4309-a84f-a5fa1d99d0db

Release:
July 2019

Product Version:
2.71.5523.941 (19.07) (x64)

Error Message:
MdxScript(MODEL) (37, 39) Calculation error in measure '#Measures'[_Gross Sales Goal]: Cannot find table ''''''''''''''''''''''''''''''''''''''''''#Measures''''''''''''''''''''''''''''''''''''''''''.

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

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

Peak Virtual Memory:
38.8 GB

Private Memory:
683 MB

Peak Working Set:
1.1 GB

IE Version:
11.648.17134.0

User ID:
164cc935-99d4-4e8c-a799-ba865e6cc393

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

Telemetry Enabled:
False

AS Live Connection:
True

Performance Trace Logs:
C:\Users\anthonya\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_NewWebTableInference
PBI_showIncrementalRefreshPolicy
PBI_qnaLiveConnect
PBI_keyDrivers

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_userFavoriteResourcePackagesEnabled

Enabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:


section Section1;

[anthonya]

The error has just occured after about 1 hr - looks to be a different error this time.  No changes to that KPI or the related measures

Feedback Type:
Frown (Error)

Timestamp:
2019-08-05T07:18:50.8662762Z

Local Time:
2019-08-05T15:18:50.8662762+08:00

Session ID:
0ea464ee-bb64-4316-988f-f6e12a3be93b

Release:
July 2019

Product Version:
2.71.5523.941 (19.07) (x64)

Error Message:
MdxScript(MODEL) (37, 39) Failed to resolve name 'SYNTAXERROR'. It is not a valid table, variable, or function name.

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

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

Peak Virtual Memory:
41.9 GB

Private Memory:
1.11 GB

Peak Working Set:
2.42 GB

IE Version:
11.648.17134.0

User ID:
164cc935-99d4-4e8c-a799-ba865e6cc393

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

Telemetry Enabled:
False

AS Live Connection:
True

Performance Trace Logs:
C:\Users\anthonya\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_NewWebTableInference
PBI_showIncrementalRefreshPolicy
PBI_qnaLiveConnect
PBI_keyDrivers

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_userFavoriteResourcePackagesEnabled

Enabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:


section Section1;

[v-diye-msft]

Hi @anthonya ,

The error you mentioned here is usually a transient issue, which I think might be related with the Data Source connection. Please try it again and see what happens. If the issue insists, then we may take a network trace with the F12 tools to have a look first. Steps mentioned in the article below could be followed to perform the capture:
Network Capture - Edge & Internet Explorer

If it doesn't work then perhaps open a support ticket with MS support.https://powerbi.microsoft.com/en-us/support/

[anthonya]

Hi v-diye-msft,

This issue occurs also on our Dev server.  And it occurs within the Power BI Desktop client

.har file is here - netwrk.har

Thanks

Anthony

[v-diye-msft]

Hi @anthonya ,

Sorry I can't repliate your issue, please kindly raise your issue to support team for more advice.

https://powerbi.microsoft.com/en-us/support/