Aaron Shumaker

My feedback

  1. 1,534 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    142 comments  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Aaron Shumaker commented  · 

    No surprise this jumped right to the top ideas. It's what we voted for originally! It'd have even more votes if you didn't hijack the other feature request and only implement it in half the product, and pretend we weren't voting for MDX cube support all along! So my votes on the other feature didn't mean what I thought it meant? You should have closed that feature in the beginning and split out two new. I think you'd have seen mdx was preferred. Very few people are going to see the change and actually come move their votes. From the beginning mdx has gotten the cold shoulder in so many ways. Why would you try to force your customers onto tabular when there are so many scenarios that are more difficult. Tabular is a solution that makes 90% of scenarios easier and 10% nearly impossible. It's the same mistake MS made with ASP Web Forms in effort to make development easier they painted you into a corner that made alot of things nearly impossible. This and named sets are important features to producing flexible reports that will meet customer needs. The work arounds are ugly and produce a poor experience for the customer.

    An error occurred while saving the comment
    Aaron Shumaker commented  · 

    So my votes on the other feature didn't mean what I thought it meant? You should have closed that feature in the beginning and split out two new. I think you'd have seen mdx was preferred. Very few people are going to see the change and actually come move their votes. From the beginning mdx has gotten the cold shoulder in so many ways. Why would you try to force your customers onto tabular when there are so many scenarios that are more difficult. Tabular is a solution that makes 90% of scenarios easier and 10% nearly impossible. It's the same mistake MS made with ASP Web Forms in effort to make development easier they painted you into a corner that made alot of things nearly impossible.

    Aaron Shumaker supported this idea  · 
  2. 2,875 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    351 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →

    We’re looking into this request, thanks for everyone’s votes and comments.

    It looks like many of the requests will be addressed by the new ‘Sticky filters’ capability. Now when you log out of Power BI and come back to a report, the same items will be selected as when you left.

    For those who’re looking to have a ‘last month’ selection, the relative date slicer might help.

    Those with comments about currencies where having multiple selected makes the report meaningless – the report will load with whatever selection the author saved, so if you save it with one currency selected your users will see that by default.

    If there are scenarios that these features don’t address, please let us know in your comments – if you are really specific it’ll help us build the feature to work just the way you want!

    Thanks again!

    Aaron Shumaker supported this idea  · 
    An error occurred while saving the comment
    Aaron Shumaker commented  · 

    Another reason to have a default selection and not allow "All" for a slicer is sometimes we have reports that are reporting on a very detailed level that you would want to force the user to slice to avoid overly large queries.

  3. 434 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    75 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Aaron Shumaker commented  · 

    Common requirement for my users are dashboards/reports with rolling 3 months figures. This feature was closed for Excel, and PowerBI doesn't support either. https://connect.microsoft.com/SQLServer/feedback/details/619958/named-set-cannot-be-used-as-filter-when-browsing-a-cube-in-excel

    Aaron Shumaker supported this idea  · 
  4. 16 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Aaron Shumaker commented  · 

    Sometimes it takes up to an hour for SSAS Dimensional model changes to be reflected in PowerBI :(

    Aaron Shumaker supported this idea  · 
  5. 1,098 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  18 comments  ·  BI in SQL vNext » Reporting Services  ·  Flag idea as inappropriate…  ·  Admin →
    Aaron Shumaker supported this idea  · 
  6. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Aaron Shumaker shared this idea  · 
  7. 240 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  36 comments  ·  Power BI Ideas » Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Aaron Shumaker supported this idea  · 
  8. 260 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    20 comments  ·  Power BI Ideas » Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    Aaron Shumaker supported this idea  · 
  9. 161 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    12 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Aaron Shumaker supported this idea  · 
  10. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Aaron Shumaker supported this idea  · 
  11. 264 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    22 comments  ·  Power BI Ideas » Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  Fetiye responded

    We are currently working on the support to re-open pbix files from desktop.

    An error occurred while saving the comment
    Aaron Shumaker commented  · 

    I want to point out that it's not just being able to edit datasets/reports published previously, but when creating a new report, the user should be able to select the existing gateway/data source instead of specifying server/database names for SSAS.

    An error occurred while saving the comment
    Aaron Shumaker commented  · 

    Spent alot of time putting together all the pieces of the DW/SSAS/PowerBI stack, got gateway and data source setup, only to find that PowerBI Desktop doesn't leverage the gateway or data source.

    This results in several very disappointing realizations:
    1) Desktop users need DIRECT access to SSAS. Not all users are on the same local network, and so PowerBI was a great option to create a common cloud based reporting portal. SSAS is on a VM that is not on the same network as the users, so without a lot of additional networking they will not be able to access SSAS directly. The whole point of the Gateway installation was to give PowerBI access to SSAS without any complex networking/VPN setup.
    2) Lay users have to know server names/database names to connect to SSAS. If they could simply browse to and select an existing Datasource/Gateway that was configured in the portal by IT, they don't need to know any "magic values".
    3) Decentralizes management of the datasource/connection, taking management out of the hands of IT. As other commenters point out, DB or server name changes will disrupt a multitude of published reports/dashboards, and since they were not created from a centrally managed datasource/gateway, it will be difficult to update them all easily.

    The data scientists/experts who would be creating and publishing reports/dashboards do not have direct access to SSAS. Why bother creating a gateway if it is not going to be leveraged?

    Desktop right now doesn't fit into an Enterprise architecture. As DrJohnT points out, you are not giving IT proper control over the datasource. Generally with this type of platform you have a few data scientists/analysts creating dashaboards, and publishing those for business users to consume. IT needs to be able to expose a common data source for those analysts to use. Thus allowing IT to modify the properties of the data source later if needed. Having users create their own data sources is going to quickly turn into a maintenance nightmare. They shouldn't need to know about server names or database names.

    Aaron Shumaker supported this idea  · 
  12. 126 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Aaron Shumaker supported this idea  · 
  13. 1,022 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    88 comments  ·  Power BI Ideas » Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    under review  ·  Sirui Sun responded

    Hey all!

    We’ve continued to make progress here, so I wanted to update this thread with our current capabilities for maintaining security on dashboards/reports.

    As always, all of this information can be found in our Row-Level Security (RLS)documentation: https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/

    > If you have set up RLS in Analysis Services, Power BI will send the signed-in user’s credentials to Analysis Services, and respect the RLS rules set up on the on-premises model.

    > Separately, you can set up RLS in Power BI for data sources that you import or connect to via DirectQuery. This process starts in PBI Desktop, where you define roles, and write DAX to constrain what data these roles can see. As part of this process, can you use the UserPrincipalName() DAX function to get the current signed in user’s UPN (e.g. joe@contoso.com). Then, once you publish to service, you can assign users to these…

    An error occurred while saving the comment
    Aaron Shumaker commented  · 

    Reoccurring problem every time I look at any of the prebuilt PowerView, PowerBI, etc. frontends for SSAS. If you were doing front end application development yourself, then you can weave the user context into the query.

    Aaron Shumaker supported this idea  · 
  14. 21 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Power BI Ideas » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    Aaron Shumaker supported this 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.