How can we improve Power BI?

Automatic date hierarchy for direct query data

Automatic creation of a date hierarchy for date fields only seems to work for imported data. Please enable the same feature for direct query data!

212 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Sokon shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    25 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        We clearly all need this feature asap. What is the timing for this to be accomplished? Thanks

      • James Midgley commented  ·   ·  Flag as inappropriate

        Please provide this functionality asap. It one thing to be able to do this based upon import model. Stakeholders want to see real-time so import model simply won't suffice

      • Justine Lemanowicz commented  ·   ·  Flag as inappropriate

        This is a huge inconvenience. One of the benefits of this tool is that my team has access to real time data. Now, I can only use import and this is a pain point for me. I'm not sure why that changed, but this is a bad call on your part. Please fix this.

      • Annette Boulter commented  ·   ·  Flag as inappropriate

        This is absolutely vital for Direct Query - need to be able to create graphs by month and year as well as actual date :(

      • Roy Golisano commented  ·   ·  Flag as inappropriate

        Honestly I can't understand how NOT having date hierarchy available in DirectQuery only has 105 votes!

      • Roy Golisano commented  ·   ·  Flag as inappropriate

        DirectQuery is the next step in evolution for my previous import based reports, many of them use date hierarchy to present trends etc. in graphs... I don't have the option of creating my own fields and fixing sort issues etc. in order to do what I've been doing in my reports up until now. Please get date hierarchy support into directquery soon!

      • Alex commented  ·   ·  Flag as inappropriate

        I'd like to add that this should also be made available for connections to Analysis services. I'd like to take it a step further actually and make it so you could setup a default date hierarchy based upon a custom date table.

        We have a need to report on date formats that aren't standard and to use these in reports currently requires importing multiple date tables and setting up relationships for the sole purpose of date hierarchies.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Agree this is a big limitation. I use power embedded and have a lot of graphs in the dashboard whit the months of the year on the x-axis. If I want use date hierachy in my graphs I have to switch to import and use the API to upload the reports manually.

      ← Previous 1

      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.