Forum Discussion

bianchinod's avatar
bianchinod
Icon for Advocate I rankAdvocate I
9 years ago

Date Hierarchy not showing

I have a problem with Date Hierarchy. After the last sw update (Version: 2.40.4554.421 64-bit (ottobre 2016)) it seams that power bi does not show the date Hierarchy. I'm using a direct query c...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

bianchinod 


I download the October version and install it. The first screenshot is the source date, and I load it to Power BI desktop shown in second picture. It displays date hierarchy as expected. Please download the update and load dates, then check if it is successful. 

    


If you have any question, please feel free to ask.

Best Regards,
Angelia

bianchinod's avatar
bianchinod
Icon for Advocate I rankAdvocate I
9 years ago

thanks for your answer, if I import the data in Power BI (from both excel or a DataBase) it works correctly,

my problem is that Date Hierarchy is not working when I use a direct query connection to a DataBase.

 

 

 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    bianchinod 

    As I tested, I import data using Power Query, the data column still show hierarchy as the following screenshot, could you please post your snapshot for further analysis?



    Best Regards,
    Angelia

    • bianchinod's avatar
      bianchinod
      Icon for Advocate I rankAdvocate I
      9 years ago

      thanks.

      in order to see the problem you should use a "direct query" connection to a DataBase (not "import")

       

      Looking into the Forum I saw that maybe it could be a limit of the "direct query" connection.

       

      regards

      • akhelif's avatar
        akhelif
        New Member
        9 years ago

        Anyone please? I am having the same issue.