Hello,
I have a cloud hosted D365fo developer machine, my current version is: Installed product version : 10.0.15 (10.0.644.20002) and Installed platform version : Update39 (7.0.5816.41512)
I want to see the standard reports hosted by several workspaces like Cash Overview, which use power bi reports, but It's not working for me.
Is this integration - between Power Bi and D365Fo developer machine - possible in the first place ?
I've found an old post from 2017, Accessing Analytical Workspaces and Reports on 1Box environment
https://docs.microsoft.com/en-us/archive/blogs/dynamicsaxbi/accessing-analytical-workspaces-on-1box-environment
Is this still an issue 4 years later ?
I have a power BI account and I also configured the integration between D365FO developer machine and Power by following this link
https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/configure-power-bi-integration
I've used Power Bi App registration tool (https://app.powerbi.com/apps), to register D365Fo dev machine into Azure App Registration and this is the result:
API permissions:
In ax, System Administration > Power BI configuration I have this configuration and the authentication worked.
Then I've tried to publish the reports but I get a generic error, without much details :
The error:
Also when I try to run the Cash Overview workspaces I get this:
So, what I'm missing here? How this integration between Power BI (which is an azure service) and d365fo actually works? As far I've understood, standard ax workspaces use power BI embedded in order to display the reports? How data is transfer between ax and power BI ?
1- Embedded PowerBI Report (you can find it under workspace dashboard > Analytics) and you don't need to configure it on UAT and PROD (what about dev machine ?)
2- Integrated PowerBI Reports (This type need the configuration in System Administration > Power BI configuration and then you need to deploy the reports to powerBI.com)
I guess that Integrated PowerBI Reports are external reports with multiple datasouces that you can pin them in AX. You can deploy the standard AX powerbi reports to powerbi.com and use them as integrated reports too..
For configuration I've also check with the steps shown here: https://www.youtube.com/watch?v=TAPRZmD1898
There is a video about how to setup power Bi on DEV machine (https://www.youtube.com/watch?v=tDDA58xJOUM) but it's a workaround about how add the standard power BI reports back into ax not executing embed the power BI reports
So, any ideas about how to make it work ?
