Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Power BI in Business Central ( On-premise )

Posted on by 10

Hi,
I have Business Central 17 on premise and i have PowerBI report server setup , what i'd like to achieve is to embed dashboards from the report server into BC17.

Do you have any suggestions ? 

Thank you

  • Steven Renders Profile Picture
    Steven Renders 4,998 Super User on at
    RE: Power BI in Business Central ( On-premise )

    No, not by default, you will need to program that... maybe via a client-addin?

  • RiyadhBen Profile Picture
    RiyadhBen 10 on at
    RE: Power BI in Business Central ( On-premise )

    Hello , 

    Thank you for your answer ,

    But this solution requires to go by Power BI service which is in the cloud , isn't it possible to use Power BI Report server in the local network ? 

  • YUN ZHU Profile Picture
    YUN ZHU 63,992 Super User on at
    RE: Power BI in Business Central ( On-premise )

    Hope this will help.

    How to embed a Power BI report into Dynamics 365 Business Central (Business Central and Power BI)

    https://yzhums.com/4637/

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Power BI in Business Central ( On-premise )

    Riyadh,

    Happy New Year. Try this:

    To embed Power Bi reports in D365BC, steps are the following:

    1) create the report in Power BI connected to D365bc data

    2) Publish the report to your Power BI Service workspace

    3) In Business Central, when you go to a Power BI section and click on Select Report you can see all your reports published in your workspace.

    You cannot directly embed an offline Power BI report (.pbix file).

    Thanks,

    Steve

  • RiyadhBen Profile Picture
    RiyadhBen 10 on at
    RE: Power BI in Business Central ( On-premise )

    Hello , 

    First of all thank you for your response and happy new year , 

    I checked the guide it only shows how to get data from Business Central to Power BI , but i couldn't find how to publish the created report/dashboard on Business Central to view it there directly instead of the default dashboards of BC

    thank you

  • Suggested answer
    darcnus Profile Picture
    darcnus 235 on at
    RE: Power BI in Business Central ( On-premise )

    You will need to do a bit of work, but this should help:

    docs.microsoft.com/.../across-how-use-financials-data-source-powerbi

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,835 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans