Get Data using SQL Server o Microsoft dynamics 365 Online in Power BI and Embed the Power BI report as Dashboard in Dynamis 365
We will use the above report to embed in Microsoft dynamics 365
We have added only account and contact entity with some field to demonstrate how Relationship are pre-build and we get Lookup name and Id
Once published, we will edit credentials as OAuth
Navigate to My Workspace -_ DataSets and edit credentials
5.Selecting Authentication Method as “OAUTH”
6.Remember to enable Below.
End users use their own OAuth2 credentials when accessing this data source via DirectQuery.
7.Now we will ping Report as live so it can be used in dynamics 365
8.Navigating to report from workspace
9Once pinned, we can see a pinned item in DashBoard, and will also be available as a dashboard in D365
10.I have changed name while pinning it as a dashboard
11.Navigating to D365 Dashboard
Clicking NEW, Either select Microsoft dynamics 365 or Power Bi Dashboard.
12.Select Layout
13.Select Power BI Tile
All our Dashboard in Selected workspace will be available
Table of Contents:
00:00 – Introduction
00:32 – Publish Bpower BI Report
01:12 – Edit Cerdentions OAuth in Power BI
02:53 – Pin To Live
03:23 – Embed Power Bi in D365
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy
Privacy Overview
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are as essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.