Forum Discussion
date no hierarchy
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.
Sensational. Double clicked on DirectQuery at bottom right, allowed me to switch. Chugged away for 20 seconds doing things and then I created a new visual. Dragged in the ReferenceDate and it worked. Shame it didn't explain the limited functionality when I was creating the direct query. This also means that you need to setup some process to refresh the data but I'll get to that eventually.
Thanks again.
Helper IDear MonkeyBoy,
I have a same problem as you had like on the post I wrote today
Could you please tell me the details how to solve the problem?
I could not find where the " Double clicked on DirectQuery at bottom right, allowed me to switch."
Problem details (Posted on Power Bi Fourm)
Sincerely,
Lee, Hong Gwoo
- Sokon
Advocate V
This issue doesn't seem to be solved. If you want to support the referring idea, you are highly welcome: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16835431-automatic-date-hierarchy-for-direct-query-data
On the bottom right of your report page, there somehing that says 'storagemode (click to change)'
If you click it, it'll pop up with a message about switching all tables to import mode.
So ... it looks like i'll have to write SQL to get the date parts I need - because I need to use direct query also.
Cheers
