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...