web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

NAV 2018 Integration with power bi - Interaction Feature

(0) ShareShare
ReportReport
Posted on by

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)
  • Suggested answer
    Mohamad Vajid Profile Picture
    Microsoft Employee on at

    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

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans