Forum Discussion

phelmsdk's avatar
phelmsdk
Icon for Advocate I rankAdvocate I
1 year ago
Solved

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

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...
Need Help
  • MFelix's avatar
    MFelix
    1 year ago

    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/

     

     

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
1 year ago

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/