Skip to main content

Connecting Power BI to Dynamics 365 Business Central

Originally posted on February 26, 2020

What is Power BI?

Power BI is the newest visualization reporting tool from Microsoft that you need to learn. If you’ve heard about it you already know why, but if not then you’re in the right place. With this blog, we’ll start with connecting Power BI with Microsoft Dynamics 365 Business Central. 

There are several licensing options when it comes to using Power BI which can be found here

Getting started with Power BI

Within Business Central depending on your role you’ll see a blank Power BI Reports section. To get started simply click on the Get Started with Power BI link. Business Central will link with Power BI and you'll be asked to enter in your Power BI credentials for license verification. Once your logged in successfully you'll see within Business Central that your Power BI reports are being deployed.    

Select Reports

Select reports allows you to enable and disable reports that you'd like displayed in BC. Most companies start with one or two reports, however as time goes on you'll have more and more reports to choose from, presuming you or someone within your organization is building new ones. Remember to come into the Select Report option to enable reports later on.

Once you have the reports selected they will display in the Power BI Reports section of your BC landing page. You're able to toggle between the reports by clicking on the Power BI Reports header and selecting previous report or next report. One of my favorite features about connecting to Power BI is the reports also show up in the Business Central mobile app.

What's Next?

There are plenty of resources to get you started on building reports using Power BI, some of which are listed below. One of the most important ones to consider is the PowerBIUG. This is a community based user group made up of end users, Microsoft partners and consultants. There is so much learning within this community from Power BI exchange, webinars, conferences and local user groups. Check it out today. 

Microsoft allows you to try Power BI for free, so what are you waiting for?


Popular posts from this blog

My DynamicsCon experience

DynamicsCon is a first-of-its-kind, free virtual learning experience for Microsoft Dynamics 365 (D365) and Power Platform users and professionals. Although it came out of the blue it was put together by a stellar team and it was highly successful in my opinion. 
In my opinion this event was successful because there was a need in the Dynamics community for high quality, free learning. DynamicsCon required all sessions to be prerecorded, and on top of that there was a live chat during every session where the presenter could interact with the audience. This was very new and very exciting for the attendees, especially during this world where all conferences are being cancelled or switched to virtual.  Sessions I attendedWhile there were several sessions within the Dynamics 365 Business Central track I only attended day 1 for the functional sessions. Below is a list of the sessions I attended. I've been consulting for D365BC for three years now and I was able to learn so much from each o…

Community Summit 2020 is next week

Community Summit North America is set to kick off next week October 7-9, 2020. 
Community Summit is one of my favorite conferences of the year. This year is sure going to be different since it's going to be held virtually. Not being able to hug my friends and meet many others in person is going to be the hardest part of attending virtually for me. Please give us speakers grace and know that we have all prepared for countless hours to present; however presenting virtually is going to be such a different experience since we won't get to see all your smiling faces in the crowd!  CommunityOne of the biggest things about Community Summit is the "community." Each UG has their own community, but lately the lines are becoming more blurred. Since Microsoft has introduced the Power Platform and it's capabilities across all Dynamics products, I've been able to learn from many other community users, consultants, and MVPs. Bringing people together and being able to learn fr…

My story to becoming a Microsoft Most Valuable Professional (MVP) for Business Applications

I've officially been a Microsoft MVP for 13.5 hours, but who's counting. I wanted to sit down this evening and write about how I felt this morning when I opened the email from Microsoft letting let me know that I was awarded the 2020-2021 Microsoft MVP award for the category Business Applications.

My story isn't that different from other MVP's in the sense that we all love our jobs and we love helping the community. It's been a personal goal of mine since 2019 to get a nomination and it wasn't until February 2020 that I actually wrote "Goal MVP" on the board in my office. I decided early on that I was never going to ask an MVP to nominate me because deep down I wanted someone to see the hard work I was putting into presenting at conferences, blogging, and the passion I had for the Microsoft Dynamics community. After all my whole career is based on people believing in me and giving me a chance to do something I've never done before.
First job - proc…