Forum Discussion
jerarquias
Hola a todos, estoy trabajando con Power BI en modo DirectQuery y tengo un problema con la columna de fechas de mi base de datos. A pesar de configurar la columna como Fecha/Hora en el Editor de Consultas, no se me genera ninguna jerarquía de fechas. Cuando intento crearla manualmente, me arroja un error y no se crea nada.
Además, traté de construir un modelo (por ejemplo, usando una tabla de fechas o relacionando la columna “Fecha de escritura” con otra tabla), pero cada vez que intenta establecer esa relación, obtengo un error y la jerarquía no funciona.
¿Alguien sabe cómo solucionar este inconveniente para poder trabajar correctamente con la intensidad de fechas en un entorno DirectQuery? ¡Gracias!
Hi Anonymous
This a limiation when using DirectQuery.
DirectQuery in Power BI - Power BI | Microsoft Learn
You could click to upvote this idea or add your own comments.
As a workaround, you could create a custom date hierarchy manually. Please create [Year], [Quarter], [Month], [Day] columns first, right-click the original Date column and choose 'New Hierarchy', then, drag [Year], [Quarter], [Month], [Day] columns to place them under [Date] column.Power BI Hierarchy: Create Hierarchy in Power BI in 7 Steps
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi Anonymous
This a limiation when using DirectQuery.
DirectQuery in Power BI - Power BI | Microsoft Learn
You could click to upvote this idea or add your own comments.
As a workaround, you could create a custom date hierarchy manually. Please create [Year], [Quarter], [Month], [Day] columns first, right-click the original Date column and choose 'New Hierarchy', then, drag [Year], [Quarter], [Month], [Day] columns to place them under [Date] column.Power BI Hierarchy: Create Hierarchy in Power BI in 7 Steps
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-pnaroju-msftCommunity Support
Thank you, Anonymous, for your response.
Hi gbalza,
We would like to check if the solution provided by Anonymous has resolved your issue. If you have found an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.
If you found the response helpful, please mark it as the accepted solution and add kudos. This recognition benefits other members seeking solutions to similar queries.
Thank you.
- v-pnaroju-msft
Hi gbalza,
We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.
If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.
Thank you. - v-pnaroju-msft
Hi gbalza,
We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.
If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.
Thank you.