Skip to main content

Posts

Showing posts from November, 2020

Deployment failed for file for PowerBI Tier2 Environment Dynamics 365 Finance and Operations

There is a requirement in a client to create a custom report of PowerBI and embed it in Dynamics 365 Finance and Operations. So, I started searching on google and found 3 ways to connect PowerBI with Dynamics 365 Finance and Operation. OData (Direct call data entity) Azure DB (Export from BYOD) Entity Store (Create Measure to direct query from D365 Finance and Operations) So, I saw Microsoft is using Entity Store to connect their standard (OOB) PowerBI report with D365 Finance and Operations. I have created a new PowerBI app registration in dev instance and configure in Dynamics 365 Finance and Operations. then create Measure with my required dimension and build the project to show the Measure in Entity store. After clicking refresh, I can see my Measure tables in the AxDW table. I had another issue. After refreshing Measure there was no Refresh log created in Tier 2 environment. So, I found the Full reset batch job is in Cancelled state, so I just changed the status on waiting and