BI in SQL vNext

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Add translation support

    Support multiple languages within a model as you could in OLAP

    484 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    22 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  2. Writeback for Power Pivot /SSAS Tabular models

    Either through a PivotTable, Excel cube functions, or Power BI tools

    321 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  3. More Statistical Functions inline with Excel like NORMSINV AND TINV

    add more of the Excel Statisical function so we can actually start doing some real statistical analysis and normalization of data

    39 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  4. Improvements needed to the DAX editor in SSAS Tabular

    Many developers abandon SSAS Tabular (after their companies pay for enterprise licensing to get it) because of the development experience and they reason that if the development experience is poor that the product may be just as unreliable. The model designer has many problems and quirky behaviors when the model becomes complex (typically due to the number of tables & measures). In particular, the DAX editor can be very unwieldy. The auto-completion feature can cause more mistakes than it prevents. For example, if you were to backspace over a table and column, and then use the object list to select…

    96 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  5. Fine grained security

    Provide more granular (per-column, per-cell) security in Tabular models

    38 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  6. Parallel processing of multiple partitions in the same table in a Tabular model

    Currently the SSAS Tabular engine doesn't process partitions in the same table in parallel when loading data into the model. This is a major limiting factor on very large models.

    34 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  0 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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

    31 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  8. Add full real-time (without the restrictions of DirectQuery)

    Have the same real-time feature as the one that exists with the Multidimensional mode.

    25 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  9. power query

    Enable power query for tabular model design but most importantly enable power query refresh when importing from Excel PowerPivot

    18 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  10. Simplify time intelligence functions to work on single data sets without a date table

    Tableau works its magic with dates just based on date fields in a set. Power BI workbooks and Power BI designer would be super simplified if there was an inherent calendar built into the product based on setting a date column in a table as *the* Calendar date (the one you intend to group and set filter context in your Time Intelligence functions). This also eliminates the need to explain to analysts the variety of options for handling analysis and time intelligence functions on different dates (Order Date, Ship Date, Received Date).

    61 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  11. Support changing the data source type

    You cannot change a data source type (e.g. .scv --> sql server)
    You have to copy-past every calculated column, measure and relationship one by one and then finally delete the Original data source tab and rename the new one back to the old name.

    44 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  12. Is multidimensional SSAS support for PowerBI only going to be available with SQL 2016 or will it be available with SQL 2012?

    Is multidimensional SSAS support for PowerBI only going to be available with SQL 2016 or will it be available with SQL 2012?

    25 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  13. Tabular model - add custom word for [blank] members

    In SSAS Multidimensional it is possible to assign a custom text for members that are nulls or empty value.
    Could this be done in tabular? This would improve the usability of the models for end users, and at the same time would allow to use date-type or true/false type of columns.

    For example, if you have a date-type column where sometimes value is null, then member with empty value will be literally empty, and hard to notice or select in the filter list. So I am looking for a way to show some thing like [blank] or [empty] instead of…

    17 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  14. Improve Performance of Power Pivot Model Designer in Excel

    Actually Excel es getting really slow when working on large models (35 tables in my Case, not much data - only 30 MB). Opening Power Pivot Designer takes several minutes on an i7 machine, adding an Attribute may freeze Excel or be unresponsive about 10-20 minutes.

    The Designer in Visual Studio is far better, but not available for anyone. Please improve this.

    48 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  15. Allow an Excel workbook to switch data source to SSAS without recreating all visualizations

    Currently, you can import a tabular model from a workbook, but you can't then repoint the data connection to the imported SSAS model. This would be VERY helpful to the migration story, particularly to Dashboards and the SSAS connector.

    28 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  16. Offline/metadata only edit model

    Performing simple modifications should not cause the UX to delay/lag for 10-30 seconds

    eg changing the format mask or data type of a column in an average sized model (8 dimensions, 1 10million+ row fact) takes about 20-30sec per change. Scale that out for the whole model and all of a sudden you're spending 5-10 times longer waiting for the change to be committed than it takes to perform the change.

    I know this is because it causes the workspace db to be refreshed. But why does it even need one? Multidimensional SSAS doesn't force a deployment and process of…

    15 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  17. Fix Compatibility Issues with Power Query (tabular metadata change causes source query to go into read-only mode)

    Power Query is the method being pushed as the load mechanism for models on PowerBI. And a good thing too, PQ is probably one of the best things MS has come out in this space for a while.

    But it doesn't work well with Power Pivot. Currently the development is one way. Any changes in power pivot to a table loaded via power query renders the source query read-only. I've noticed some changes in excel that stop some modifications, but changing column metadata and formatting still breaks it.

    eg I generate a datetime using power query in one of my…

    12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  18. Tell the import that a string column in reality yields JSON objects to have those objects analyzable

    Tell the import that a string column in reality yields JSON objects to have those objects analyzable

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  19. Improve multi-user development of Tabular Models

    To allow more than one user to develop a tabular model at one time split out tables or allow multiple models in a single SSAS database.

    52 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  20. DAX editing & debugging in SSMS...

    In SSMS, only can edit MDX (drag & drop from object explorer), we need a full function DAX editor, just like DAX studio...

    36 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1
  • Don't see your idea?

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.