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.
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.
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.
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
OK, I'll see if I can switch to an import and give it another crack.
