Forum Discussion
Anonymous
6 years agoNot applicable
KPI status error
Hello,
I created couple KPI in Tabular model (1200, SSAS 14.0.249.3). I can’t use KPI Status in any report (Excel, Power BI) or Dataset on SSRS. Always I have the next error:
===================================
MdxScript(DRK_data_model) (9, 38) Failed to resolve name 'SYNTAXERROR'. It is not a valid table, variable, or function name. (Microsoft SQL Server 2017 Analysis Services)
------------------------------
Расположение программы:
в Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteTabular(CommandBehavior behavior, ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
в Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteReader(CommandBehavior behavior)
в Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteReader()
в Microsoft.ReportingServices.QueryDesigners.ASDesigner.QueryBuilderClientControl.QueryExec.ThreadExecution()
I created couple KPI in Tabular model (1200, SSAS 14.0.249.3). I can’t use KPI Status in any report (Excel, Power BI) or Dataset on SSRS. Always I have the next error:
===================================
MdxScript(DRK_data_model) (9, 38) Failed to resolve name 'SYNTAXERROR'. It is not a valid table, variable, or function name. (Microsoft SQL Server 2017 Analysis Services)
------------------------------
Расположение программы:
в Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteTabular(CommandBehavior behavior, ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
в Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteReader(CommandBehavior behavior)
в Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteReader()
в Microsoft.ReportingServices.QueryDesigners.ASDesigner.QueryBuilderClientControl.QueryExec.ThreadExecution()
1 Reply
- v-lili6-msftCommunity Support
hi Anonymous
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/
Regards,
Lin