Tabular editor advanced scripting12/20/2023 ![]() So with a simple 14 line script and no additional tools or downloads you can generate a set of data driven measures for your model. The advantage of these methods is that you don’t need to do any searching for port numbers or loading additional libraries and they make use of the existing authenticated connection, so there is no need to re-authenticate to the data model. ![]() These let you run DAX or TSML scripts directly against a connected data model. What this means is that you can just call ExecuteReader(query) instead of (query) This has now been fixed and Daniel has extended this method to return a DataSet (which can contain multiple DataTables) and he has also added the EvaluateDax method which can evaluate simple DAX expressions.Īlso these methods are also exposed as static methods. Update There was an issue with certain queries and the ExecuteDax method. As of Tabular Editor 2.12.0 the database object in Tabular Editor now has 3 new helper methods. ![]() Within an hour he actually came back with an even better approach which he had just added to Tabular Editor. The idea was that I should be able to do everything Phil did in his original script from the Tabular Editor Advanced Scripting feature. While I was writing my previous post I sent a question to Daniel who is the author of Tabular Editor, asking if there was a way of getting the connection details when Tabular Editor was launched from the External Tools. Which in turn was inspired by this excellent post by Phil Seamark. This is a follow-up to my previous post on using a combination of DAX Studio and Tabular Editor to generate a series of measures based on the values in a given column. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |