
Hello All,
I have integrated Nav 2018 and power bi . By setting up azure directory setup and creating app in azure portal.
After the integration i could select report which i created using customers page Odata in customers page of Dynamics Nav.
Now i can see the reports, but as per Nav 2018 update. I need to see the interaction betwen customer page of nav and customer power bi report.
Say it need to be react and filter the power bi reports when i selct any on record in customer page.
But i could'n t see interaction , please help me to solve this, its an urgent requirement.
*This post is locked for comments
I have the same question (0)Hello,
To filter data on the reports based upon the record selected from the list page, the primary key must be used as a report filter. The primary keys will need to be part of your data set in order for the reports to filter correctly. In most cases, the primary key for a list is the No. field.
You can follow this article:
Viewing List Data in Power BI Reports in Business Central
docs.microsoft.com/.../across-how-use-powerbi-reports-factbox
Thank you,
Mohamad Vajid