Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have no problem with creating hierarchies in .pbix (direct query).
But when I use a connection through an excel (Power BI Publisher or Analyze in Excel), I do not see the hierarchies I created.
Using a simple field "date" is not convenient for applying the filter when building a pivot table (I see all dates for all the years)
I'm looking for a solution to create a convenient hierarchy date filter for the pivot table in Excel that is connected to powerbi.com
Thanks for the help and ideas
@BI2B,
This could be a limitation of DirectQuery, when I use Import mode to connect to the data source and use "Analyze in Excel", hierarchies are available in Excel.
Regards,
Lydia
Thank you, Lydia
But I need a Direct Query mode only
The same......Did you find the solution?
@BI2B,
You can submit an idea in Power BI ideas forum.
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.