Develop embedded Powerbi Report from scratch in Dynamics365 F&O

In This article, I will show you how to create comprehensive Powerbi Report for PRQ. So the result will be like:

The Advantages of using embedded powerbi with DirectQuery:

• You do not need powerbi license.
• faster data refresh.

Let's start:

Create Query:

Create Datasource  Of PurchReqTable

then create a datasource of it "PurchReqBusinessJustificationCodes" make sure relation is outerjoin as the picture:

then create another datasource "PurchReqLine"

then create another datasource "PurchReqBusinessJustificationCodes" again the relation should be "outerjoin"

then create another datasource "HcmWorker"

this how your query will look like eventually:

Create A view based on the query:

 

The first 5 fields should come from PurchReqTable but the followings should be like:

Itemid -> PurchReqLine

PurchQty -> PurchReqLine

PurchaseOfficer -> PurchReqBusinessJustificationCodes

BusinessJustification -> PurchReqBusinessJustificationCodes

Preparer -> DirPerson

Build The Project & Synchronize

Create Aggregate Dimension with table "ADAN_PrqStatusView"

then follow this:

Create Aggregate Measurement:

Create Aggregate Data entity:

Build & Synchronize

Open entity store & refresh the newly created entity

then open Microsoft Sql Server Maganement and check the table created in AxDW:

Note: if data did not load make sure you open batch jobs and search for full reset make sure it is in executing status.

connect to Powerbi & start designing:

Once done, open back your visual basic studio project and create new item -> resource and attach the powerbi report you created

after that,you need to embed this report to the form. for this you can copy what microsoft already done for existing powerbi report like this one: