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

    503 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

    320 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. Support ragged hierarchies in Tabular through HideMemberIf equivalent

    Currently if you have a ragged hierarchy you will see blank branches/leaves in your hierarchy in your Tabular model. BIDS Helper allows you to set HideMemberIf, but since the SSAS server for Tabular doesn't officially support this, it appears to not work properly on a significant percentage of dimensions. Please support HideMemberIf or an equivalent properly.

    138 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. 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 →
  5. Support display folders for columns and measures in Tabular

    Currently Tabular doesn't support setting the display folder for columns and measures. BIDS Helper adds a UI for this should be baked into the product. Please add official support for display folders.

    68 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 →
  6. 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…

    93 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 →
  7. Export Tabular Models to Power Pivot Models

    Since it is possible to import an Excel Power Pivot model to Tabular the reverse should also be possible in order to reuse existing development work and to add improvements outside a development environment.

    65 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. 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.

    51 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. 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…)
    1 comment  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  10. Scope statements in Tabular models

    I want to build the DAX for a Month-to-Date member of a Date Calculation dimension and have it apply to every measure in the model. This would require scope statements to do in a maintainable way.

    33 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 →
  11. 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 →
  12. 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 →
  13. Improve the refresh capabilities, including APIs for On-Demand refresh

    A fixed point in time, once a day... is often not adequate. Calling an API to refresh Power Pivot model and reports connected to it... would be awesome. And it should work with Power Query connected models, if you love me.

    19 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. 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

    32 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 →
  15. 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…)
    1 comment  ·  Power Pivot / SSAS Tabular Model  ·  Flag idea as inappropriate…  ·  Admin →
  16. NUMA support for Tabular models

    Currently Tabular models don't scale well on servers with multiple NUMA nodes. Proper NUMA support should be built in as it is for Multidimensional models. This can be a limiting factor for very large models.

    20 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 →
  17. 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 →
  18. 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 →
  19. 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 →
  20. 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 →
← 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.