Forum Discussion

MonkeyBoy's avatar
MonkeyBoy
New Member
10 years ago
Solved

date no hierarchy

Complete beginner question. Using Power BI Desktop, connected to a SQL Server database with a database datetime field called ReferenceDate. On the Modelling tab, this field shows as a "Date" Date Typ...
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    Sorry, by Tabular I was referring to SSAS (SQL Server Analytics Services) or basically a cube. Although a cube is not actually Tabular. In any event, the question was directed toward whether or not you were using DirectQuery. I highly suspect that is the issue. Using DirectQuery puts a fair number of limitations in place. I just tried this with a simple SQL database table and it worked just fine. I suspect that if you import the data versus use DirectQuery that it would work just fine.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

What type of visual are you using? I just tried this on a column chart and it worked no problem. Tried this with both a Date field and a Date/Time field. Are you on the latest version of Power BI?

  • MonkeyBoy's avatar
    MonkeyBoy
    New Member
    10 years ago

    The current view is a stacked column chart however I have tried several different types.  

     

    I downloaded MS Power BI about Thursday last week and I found this under Options/Diagnostics : Version: 2.32.4307.641 64-bit (February 2016)

     

    Thanks for the quick response.

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      10 years ago

      MonkeyBoy - One other question, are you connecting to database or tabular with SQL Server and if tabular, are you importing or using DirectQuery (connecting).

      • MonkeyBoy's avatar
        MonkeyBoy
        New Member
        10 years ago

        Sorry for ignorance but I don't know what Tabular is. I have a database has a view over a star schema/dimensional model that I pointed MS Power BI at. I used the DirectQuery option to connect to that view.