INFO.VIEW.MEASURES() will not show local measures when connected to Azure Analysis Services

[phelmsdk]

I am trying to use INFO.VIEW.MEASURES() to pull out documentation in my report, but the command only shows measures stored in the Azure Analysis Services (AAS) and not locally created measures.

I also tried this command: 

EVALUATE

FILTER(

    INFO.VIEW.MEASURES(),

    NOT CONTAINSSTRING( [Expression], "EXTERNALMEASURE*"

    )

)

...but that did not work either.

Is there any way to have the local measures included when using the INFO.VIEW.MEASURES() command - or is there some kind of workaround?

[MFelix · Accepted solution]

Hi @phelmsdk ,

The INFO.VIEW is based on the semantic model so in this case since you are connecting to AAS this will not be pickedup since it's not related to the model.

The only option I believe is to create a composite model, that will keep the AAS in Direct Query mode and the new measures would be pickedup on this new semantic model.

If you don't want to change the type of your semantic model you can try to use Power BI Helper that will allow to do the documentation based on the report you select (https://powerbihelper.org/