News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) NAV 2018 Integration w...

Microsoft Dynamics NAV (Archived)

NAV 2018 Integration with power bi - Interaction Feature

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

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

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Mohamad Vajid on at

Like (1)

Report

RE: NAV 2018 Integration with power bi - Interaction Feature

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans