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!

92 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    7 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • 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.

      • Renee HughesRenee Hughes commented  ·   ·  Flag as inappropriate

        This is a severe limitation with using PowerBI because I would like to use this functionality in a dashboard that always has current data, so Direct Query is a must.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Importing is a quick fix for single uses, but not at all practical for

        The DirectQuery limitations of PowerBI are pretty appalling.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Direct Query is really required for handling big size of data in perspective of data handling performance and visualization speed. Also the date hierarchy is the far base of all the Power BI works. Therefore, if Power BI want to have its motto as "Easy Big Data" it should have automatic Data Hierarchy process function for Direct Query.

      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.