Skip to main content

Power BI

Needs Votes

scripted view of the data model

Vote (20) Share
Elena Terenzi's profile image

Elena Terenzi on 17 Jun 2015 16:47:26

Make the model scriptable would be great. Today in Power Query you have possibility to switch to the advanced view where you have the scripted version of the transformation. Having the scripted version of the data model, where measures and calculated columns for all tables are all together in a single scripted view would be useful and would speed up the data model design process

Comments (5)
Elena Terenzi's profile image Profile Picture

Power BI User on 06 Jul 2020 00:15:08

RE: scripted view of the data model

Great! If possible, I would go further. The pbix file should be splitted in two: a data file and a design file. The design file should be fully friendly (a json file?) and let set all visuals, measures, etc.

It would be great to put the file in repositories to control versions and changes (git, svn, etc).

Elena Terenzi's profile image Profile Picture

Marcus Wegener on 05 Jul 2020 23:26:51

RE: scripted view of the data model

A single script for all DAX measures, would be great

Elena Terenzi's profile image Profile Picture

James on 05 Jul 2020 22:41:01

RE: scripted view of the data model

Broadly speaking, it would be helpful to have support for bulk changes to the DAX model. I would be happy with script support and/or a GUI that allowed for inserting, updating, or deleting multiple measures at once.

See also:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17554678-bulk-editing-for-columns-measures-in-pbi-desktop

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11342637-ability-to-delete-multiple-measures-at-one-time-in

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13219620-duplicate-measure-and-format-copy

Elena Terenzi's profile image Profile Picture

Sharon.Laivand on 05 Jul 2020 22:22:24

RE: scripted view of the data model

fill in and spread this survey to help improve R in Power BI
http://www.instant.ly/s/H7YJx

Elena Terenzi's profile image Profile Picture

Douglas Day on 05 Jul 2020 22:02:46

RE: scripted view of the data model

I'd like the ability to define all my DAX measures in a single script, as opposed to using the interface.