Skip to main content

Power BI

New

scripted view of the data model

Vote (18) Share
Elena Power BI User's profile image

Elena Power BI User 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 Power BI User's profile image Profile Picture

55d4f51d 2b27-4fed-a51f-c2159fee87c9 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 Power BI User's profile image Profile Picture

914335d3 12f3-e811-a956-000d3a4f36ce 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 Power BI User's profile image Profile Picture

a6966d00 35c5-4f4f-b011-1f73ec2a9792 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 Power BI User's profile image Profile Picture

503dadc5 54d6-43dc-938c-35b4527f7edf 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 Power BI User's profile image Profile Picture

eb6d3d85 fe60-4e70-8106-52e3dbe93266 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.