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