Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Power BI Open report record in BC SaaS

(0) ShareShare
ReportReport
Posted on by 2,469

Hi All

Is there a way to configure PowerBi so when a user click on the report line it opens up the relevant page in BC? Say you have a report with invoice number rand when the user clicks on the invoice number it opens the invoice screen in BC?

Thanks

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    RE: Power BI Open report record in BC SaaS

    Hi, Maybe you can set BC Web Client URL in Power BI. But as far as I know, this cannot open the card page directly.

    For example,

    https://businesscentral.dynamics.com/d8f36038-1f93-4543-affc-5dc92b6ee871/Sandbox214?page=9301&filter='No.' IS '102204'

    pastedimage1676594131632v1.png

    pastedimage1676594142667v2.png

    More details:

    https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-web-client-urls#filter-syntax

    Hope this helps.

    Thanks.

    ZHU

  • Verified answer
    Andy Sather Profile Picture
    Andy Sather on at
    RE: Power BI Open report record in BC SaaS

    Hello Samantha - I am not aware of how to configure this in Power BI, but this would be a great feature.  I would encourage you to enter a production suggestion on our Ideas site:

    http://aka.ms/bcideas

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans