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. Looking to speed this process up? You’re in luck.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. Next, you need to set a JSON extended property on the Dimension Parameter Fields column.Īfter that is complete, click save from Tabular Editor and then manually refresh the newly created Dimension Parameter table. On the Dimension Parameter (first column) column, you need to set the Group By Columns property to Dimension Parameter Fields. These properties transform this otherwise regular calculated table into a Field Parameter. The last, most crucial steps, are often overlooked. To get the same behavior as a field parameter created in Power BI Desktop, you should also set the ‘Sort By Column’ property of ‘Dimension Parameter’ and ‘Dimension Parameter Fields’ columns, to sort by ‘Dimension Parameter Order.’ Completing the Process You can then name the 3 columns of the calculated table to match Power BI Desktop and hide the ‘Dimension Parameter Fields’ and ‘Dimension Parameter Order’ columns. To change the name of the columns, you need to first change the Name Inferred in the properties from ‘True’ to ‘False’ for each of the three columns. You’ll notice that the columns look different than in the Power BI Desktop UI.ĭon’t worry, though, these can be changed to match what is seen in Power BI Desktop through a very simple process. Next, I select the code and copy it to my Tabular Editor. Power BI Desktop generated this DAX expression that creates 3 columns, with the fields I selected in the UI to be included in the Field parameter. You can copy that DAX expression (or free hand it if you like!) and create a Calculated Table in Tabular Editor with the same expression.įor this example, I am creating a Dimension Parameter table. Field ParametersĪs you may know, when you create the Field parameter in the Power BI Desktop UI, this creates a DAX calculated table. (If your organization is utilizing Tabular Editor + XMLA endpoint for enterprise Power BI datasets, creating these in Power BI Desktop might not be an option.)Īs many of you may need to create similar solutions, I have created this step-by-step guide to help you with creating/configuring these within Tabular Editor. While there are a ton of blogs and videos already out there covering how incredible this feature is and how to set it up, I needed to figure out how to create these field parameter tables in Tabular Editor, as opposed to authoring in Power BI Desktop. They released a new gem of a featured called FIELD PARAMETERS and this blog is going to go over the benefits to you as a developer May 2022’s release of Power BI Desktop is the best releases we’ve seen in several years.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |