Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
This feature could be incredibly powerful. I have a core dataset that requires slight enrichment by each customer... which currently would result in many datasets. I'm excited at the possibility of reusing the core dataset and then enriching it.
One issue I noticed right away is that it doesn't seem like date heirachy from the Power BI dataset i'm connecting to is supported. Any chance that can get fixed?
- AnonymousPerson
Advocate V
drewlarson wrote:One issue I noticed right away is that it doesn't seem like date heirachy from the Power BI dataset i'm connecting to is supported. Any chance that can get fixed?
drewlarson I think the limitation with date hierarchies was addressed in the blog post....
You may see some unexpected behavior when using a date hierarchy. To resolve this issue, use a date column instead. After adding a date hierarchy to a visual, you can switch to a date column by clicking on the down arrow in the field name and clicking on the name of that field instead of using “Date Hierarchy”:
This behavior will be addressed later in the preview.
For more information on using date columns versus date hierarchies, visit this article. - jeroenterheerdt
not sure what you mean, can you give us some more details?
