by Ariel Netz, Group Program Manager in the Power BI Designer team
Last summer, we started our planning for the Power BI Designer, a BI desktop client tool designed to complement the Power BI SaaS offering we were already working on. As with any new project, comes lots of questions and ideas on how things will work, but a few base assumptions were made clear from the very beginning:
- We want to build a single, unified experience that will combine all the capabilities of Power Query, Power Pivot & Power View. Historically, those tools were developed at different paces, using different technologies, each designed to stand in its own right. While each of the tools did exactly what they were set out to do, our users spoke loud and clear โ they wanted to use them together and see a much better integration than what we delivered. Additionally our users provided feedback that they would like to see our tools evolving on regular and frequent cadence.
- At its core, we designed Power BI Designer to help users to visually explore data and author interactive reports and to complement Excel. Power BI Designer is available to download for free from www.powerbi.com and can be used as a standalone desktop companion
- Like many other teams at Microsoft, we will be delivering on our vision over time and, in an incremental fashion, enabling our customers to try out the tools, provide feedback on our designs and basically, keeping us honest in โreal time.”
The very next thing we did was to put together a team that is composed of experienced developers and designers who worked on theseย technologies before and asked them to build that single tool.
On Dec 18, 2014, we announced the preview of the Power BI service together with the Power BI Designer. That early build was our first showing. The Power BI Designer preview combined the capabilities of Power Query and a good portion of the Power View capabilities, but it did not show Power Pivot. I say โshowโ as behind the scenes the Power Pivot in-memory engine that glues it all together was there.
Since December, we have released updates to the Designer every month. Each of the updates included the usual bug fixing, performance optimizations and also included new capabilities.ย In the past couple of months, we worked on some smaller improvements that were designed to bring some of the Power Pivot modeling capabilities into the Power BI Designers. Some of those improvements include:
- Automatic Model-level Relationship Detection.
- Manual Relationship Creation
- Show/Hide Data Model Fields.
However, those changes still didnโt show the direction we are heading into with the integration of Data Modeling capabilities into the Designer. There are many capabilities that make Power Pivot theย bestย analytical engineย of its kindย but ofย all,ย thereย isย oneย featureย thatย isย moreย recognizedย thanย others:ย DAXย formulas.ย Anybody whoย has usedย Powerย Pivotย beforeย willย attestย thatย ourย integrationย workย willย neverย beย completeย withoutย the additionย ofย DAXย formula authoring capabilities to the Designer.
Today we are pleased to announce a series of enhancements to the Power BI Designer that demonstrate the direction we are heading with the Designer modeling capabilities:
- Initial DAX Measures functionality with Intellisense
- New DAX functions.
- Data Types (unified across Model and Query.)
- Model-level formatting.
- Rename & Delete fields in Report view.
- Updated Relationship Creation dialog
This April update is just another update amongst many more planned to come but itโs a special one as, for the first time, users will get to experience all the โPowerโ tools in a single tool โ Power BI Designer. Much more is soon to comeโฆ
Click here for full details on โWhatโs Newโ in the Power BI Designer April update
