Live Connection Azure Analysis Services - wrong BLANK measure behaviour

Status: Accepted
by FP Occasional Visitor on ‎04-13-2017 05:19 AM

I'm working with a live connection to an Azure Analysis Services instance and it seems to me that measures with BLANK values have unexpected behaviours.
This problem arises both using "Standard" and "Azure" connector.

When I put into a table, or other visual, descriptive fields and only blank measures all performs as expected.
When I put into a table, or other visual, numeric fields and a blank measures these show random values (often they are randomly choosen from a field on the same evaluation row).

For my tests I have created a measure as follows "blankmeasure := BLANK()", so I am sure it should not return any value.

Status: Accepted
by Moderator v-qiuyu-MSFT
on ‎04-14-2017 03:06 AM

Hi @FP,


The same issue has been reported yesterday: CRI 35672286. See this same thread: Power BI Null Handling from Azure Analysis Services - Issue.


Best Regards,
Qiuyun Yu       

by Moderator Vicky_Song
on ‎04-14-2017 03:08 AM
Status changed to: Accepted