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).
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...
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...
Define default selection for a column in the model
Create a property that defines the default selection for a column in a table. It is very needed in Calculation Groups, but all the tables/columns of a model could benefit. If that column is not referenced in the report, it should be filtered by default. Ideally, the default is defined by a DAX ex...
Matrix/tables should display KPI of a Tabular model like Excel
The KPI defined in a Tabular model are displayed in a different way in Power BI compared to Excel. - Excel supports decimal numbers from -1 to 1 for both 3 and 5 states graphics - Power BI supports integer numbers from -2 to 2 for 5-states graphics, and integer numbers from -1 to 1 for 3-states g...
Define query calculation items in calculation groups
Enable a syntax to define/replace a calculation item of a calculation group in a DAX query. DEFINE CALCULATIONITEM 'Time Intelligence'[Time Calc]."YTD" = CALCULATE ( SELECTEDMEASURE(), DATESYTD ( DimDate[Date] ) )