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.
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
Business Applications communities