Analysisservices issue

[Anonymous]

Hi ,

The data source is connecting to Analysis Services tabular data model. But the challenge is users are unable to edit the formatting of measures which are directly coming from analysis services. Is there any way to fix this issue?

Also, another challenge is, have deleted tables in analysis services, but still, these are appearing and asking me to hide every time whenever the report opens. How to fix this issue.

[v-juanli-msft]

Hi @Anonymous 

Is your connection import or direct query/live connection?

If it is imported, you could use Format Dax function to format a measure.

If it is direct query/live connection, the format of the measure is determined from the data type of the column referenced in the formula expression automatically.

Best Regards
Maggie