Provide API & Library to create local PBIX files
Enable ISVs and system integrators to generate "personal" PBIX files that have a ready-to-use data model and set of filtered data so that a user can navigate into an "exported" dataset. It would be very useful in many applications and service. This could be the format to exchange data models and ...
Add a Data Model Language for SSAS Tabular
Create a data modeling Language based on a textual representation (such as SQL DML, no XML) that would enable comparison between versions and easy copy/paste between data models
Remove schema name (or keep it optionally) importing tables or views from SQL Server
When you import tables or views from SQL Server, the schema name is placed before the table/view name. When you import several tables/views from the same schema, this is really useless. Having the option to keep the schema name only on-demand during the import would be very useful.
Power BI Designer API
Power BI Designer saves a local PBIX file, which can be a file to export data and data model – in other words, it’s a format that contains a complete semantic model. All the applications that today export data in several formats (CSV, Excel, XML), might provide a richer semantic model exporting a...
Language support for Power BI Analysis Service Connector
The Power BI Analysis Services Connector should support changing the connection string, so we can add special parameters (such as changing the language).
Support creating calculation groups in Power BI Desktop
Support the creation of DAX calculation groups in Power BI Desktop - otherwise Power BI can only consume calculation groups created in Analysis Services, whereas it would be very useful to have this feature in any Power BI model. Even just a simple text window with a script would be fine. You ca...
Customize visible items in new filter experience
The standard slicers have now a visual level filter, but the new filter experience does not have a similar feature. A correspondent "visual level filter" allowing to define conditions that make an item visible or not. in the new filter experience. The reasons are the same that justified visual le...
Improve performance of MDX queries using Analyze in Excel
When you use Analyze in Excel, MDX queries are sent to the Power BI dataset. If you have a PivotTable with 10 measures, the performance is usually slower compared to a similar Matrix in Power BI with the same content. Power BI generates DAX queries. One of the reasons why this difference exists ...
DAX calculations at visual level of reports
Provide a simple way to write formulas that work with the data displayed in a visual. For example, the running total of a measure in a table or in a chart according to the sort order of the visual should be something like this: Running Total = ReportData[Sales] + PREVIOUS ( ReportData[Running...
Selection of arbitrary combinations of measures and other table/column items in visuals
When I combine measures and the content of a column in a matrix, I always get the visualization of all the combinations. For example: - Measures: Sales Amount, Sales YOY% - Year: 2020, 2019 The visual displays 4 combinations, producing the cartesian products of all the measures and all the years...