SSAS KPI not working in Power BI (or Excel)

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;