Andrew Peterson

My feedback

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

    We’ll send you updates on this idea

    77 comments  ·  Power BI Ideas » Reports  ·  Flag idea as inappropriate…  ·  Admin →
    Andrew Peterson supported this idea  · 
  2. 47 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 » Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Andrew Peterson commented  · 

    Yes, we can build views as a work around, but many of the report writers do not have permissions to create a view. Just read access. We're training staff to use CTE's as it provides a great way to isolate complex query logic. Much cleaner than using sub-queries. From the perspective of self-service, lack of support for CTE's is limiting. We have an on-premises version ( PBIRS) so direct query is superior for real-time data access.

    Andrew Peterson supported this idea  · 
  3. 19 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 →
    An error occurred while saving the comment
    Andrew Peterson commented  · 

    While technically, it looks like we can adjust using the 'Advanced Editor" it is not easy.
    We can do this if the query is an SQL. But not sure why there is no way to edit using standard MDX/DAX.

    Andrew Peterson 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.