Jay Killeen on 26 Feb 2016 09:06:11
Excel has both Power Query and VBA.
It would powerful to also have a programming language and interface for PowerBI Desktop to help in auto generation of M Language queries and also interacting with the report and dashboard objects.
This could be using TypeScript so you have the custom visuals and also the DOM as an available object to build things like user input forms that can then be passed to the Query M Language to make queries more dynamic.
- Comments (1)
RE: Provide a Programming Language for PowerBI Desktop
This looks to be related to https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9714537-page-level-filter-default-values-by-formulas-scrip and https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12401346-could-we-have-a-script-editor-in-pbi-desktop-that
and possibly https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12942396-dinamically-apply-filters-for-embedded-report
Basically all ideas are getting at having programmatic control over the UI/UX interactions, data selectivity.
Idea moderators, any way we can combine votes on similar topics?
Rolland