Forum Discussion

smpa01's avatar
smpa01
Community Champion
2 years ago

DAX INFO callbacks

jeffrey_wang AlexisOlson GilbertQ DataZoe 

 

I am calling INFO.EXPRESSIONS() on the ssas db tables. For some db, it is returning a result set containing expressions for each and every table but for some it does not return anything (returning absolutely no result). For some it is returning result for a subset of db tables.

 

I have tested this on a varierty of db containing tables coming from a varierty od dataset.

 

What might be casuing this?

 

I desrire it to return expressions for each and every table.

 

Thank you in advance.

Need Help

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi smpa01 

     

    I'm going to make the assumption that the semantic models that are not returning any information are older versions of the letter compatibility model and the Dax.info does not exist in those semantic models. to fix this, you would have to upgrade the compatibility mode.

    • smpa01's avatar
      smpa01
      Community Champion
      2 years ago

      GilbertQ how can I upgrade the compatibility mode without destructing any component of it?

      • smpa01's avatar
        smpa01
        Community Champion
        2 years ago

        GilbertQ  just so you know, I tried to upgrade manually from ssms and tabular editor but I could not; it is not letting me change it as the value is not editable. I am not sure how can I upgrade the compatiability level.

         

        I tried this in XMLA which did not work

         

         

        <Alter xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
	<Object>
		<DatabaseID>3cd01553-784f-44c9-9beb-1a7f2f591b7b</DatabaseID>
	</Object>
	<ObjectDefinition>
		<Database>
			<ID>3cd01553-784f-44c9-9beb-1a7f2f591b7b</ID>
			<Name>Stats</Name>
			<CompatibilityLevel>1600</CompatibilityLevel>
		</Database>
	</ObjectDefinition>
</Alter>