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.
Dear 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
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