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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I'm having the same issue!

 

I introduced another query with the name date as I wanted to create a relationship between two tables that were completely different from each other. By bridging them with a familiar set of data such as the date column, I could collect data from each of them.

 

The problem started as soon as I created this table. I went back to another dashboard and noticed that the 'Document Date' in one of my dashboards was was no longer working. It wouldn't let me use it's hierachy...

 

Any ideas?