search

TabularEditor / TabularEditor3

Bug reports, feature requests, discussion and documentation for Tabular Editor 3 (commercial version).
65 stars 7 forks source link

Allow Use of [EnableFolding] parameter for Value.NativeQuery function #452

Open EthanEverett opened 2 years ago

EthanEverett commented 2 years ago

Is it possible to enable the optional [EnableFolding] parameter that can be added to the Value.NativeQuery function in M/Query Editor? This parameter works in both Excel and PowerBI but not in TE3 which says that the only valid parameter for Value.NativeQuery is (none). The following string is an example of the function working with the optional parameter in Excel and PowerBI: Value.NativeQuery(xxx, "SQL Statement", null,[EnableFolding=true])

image

otykier commented 2 years ago

Hi @EthanEverett The error message you are seeing originates from Analysis Services - not Tabular Editor. You would see the same error message if you attempted to refresh the table / model through SSMS.

Are you working against the Power BI XMLA endpoint, or an instance of SSAS / Azure AS?

EthanEverett commented 2 years ago

The model is deployed on an instance of SSAS.

otykier commented 2 years ago

Are you certain that SSAS even supports the EnableFolding parameter? To my knowledge, this parameter only works in a Power BI model.