Announcements
No record found.
How to show the product category lookup hierarchy in the power bi report by combining D365 FO tables?
Hi Pravasti,
Can you explain more as your question is not clear enough for me to exactly understand what you want to achieve and where you get stuck.
Hi Andre,
We are creating a power bi report using SQL views, requirement is to show the product category hierarchy lookup as a slicer.
this issue should addressed to Power BI issue not D365?
Hi Pravasti
I would suggest the following steps in order to achieve the requirement.
Find the EcoResProductCategoryHierarchyEntity in Visual studio and make a list of tables that are part of the data entity.
Export those tables to your PowerBI database.
Then find the EcoResProductCategoryHierarchyEntity in Dynamics 365 Finance & Operation database in the View section.
Copy the view and create it in your Power BI database, and make sure that you should have all the tables in your BI database before creating a view.
By following the above steps, You can achieve your requirement.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 512 Super User 2026 Season 1
Giorgio Bonacorsi 386
Adis 259 Super User 2026 Season 1
