Overlapping between Power BI designer and Excel are confusing
At the time of this Preview, MSFT is marketing the new Power BI report designer as a tool for those who don't have Excel 2013.
However upon using the designer it is quite evident that it has features that Excel 2013 does not have, such as the ability to have many-to-many relationships without DAX coding and additional chart types (e.g. trees).
Plus the Power BI file extension denotes that this seems to be a completely different report format from what we can do in Excel (xlsx files and embedded Power View rdlx). I am wondering if MSFT plans to reconcile those new features in Excel, as well as to push some of the Power BI / SharePoint online features back to on-premise.
Please do not neglect those of us with on-prem deployments.
Hi Pedro. The Designer will often have features in advance of Excel as it can be updated more frequently. However, we do want to push as much as possible into Excel in the future.
To your point about on-premises deployments, there’s another suggestion to support that here: http://support.powerbi.com/forums/265200-power-bi/suggestions/6867727-use-power-bi-alongside-ssrs-on-prem-sql-server-201 so please add your support there!