Power BI on cloud hosted dev machine

(0) Share

Report

Posted on by FlorinF

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 ?

I have the same question (0)

All responses (13)

Answers (1)

Suggested answer

AR-01121610-0 4,967 Moderator on at

Like (0)

Report

Hy,

this document works for me before a few weeks, may be you compare this with the steps you executed.

For using PowerBI embedded you need not to use "deploy PowerBI" reports inside Dynamics. This is only required if you want to use standard or modified PowerBI reports with D365FO data outside Dynamics which mieans inside PowerBI Service.

When the setup is correct and complete, the embedded PowerBI Reports will be deployed automatically by Dynamics the first time you call the report. Therefoe it takes a moment at the first call, not at the followinmg calls.

Hope this helps

Was this reply helpful? Yes No
Suggested answer

Ajit 8,755 on at

Like (0)

Report

PowerBI.com configuration is not required to get the Power BI Embedded work but for one box VM, you would have make some adjustments. Refer - onedrive.live.com/

Was this reply helpful? Yes No
FlorinF on at

Like (0)

Report

This document is from year 2017 and Workspace collections are deprecated .

Anyway, the scenario presented in that document is to create a separate Azure sql database for AxDW which basically means

to create a BYOD setup. The question is why I can not access the the power BI from AX ? The error is very generic as usual. No clue about what is wrong

Was this reply helpful? Yes No
Ajit 8,755 on at

Like (0)

Report

As far as I know Power BI can't connect database on local VM, it has to be on Azure. Did you try to open that workspace with Power BI in tier2?

Was this reply helpful? Yes No
FlorinF on at

Like (0)

Report

Which document are you referring to ? Did you manage to make it work on your dev machine ?

Was this reply helpful? Yes No
Ajit 8,755 on at

Like (0)

Report

I did but long time back using the one I shared. But now I am using tier2 instance for all Power BI Embedded testing.

Was this reply helpful? Yes No
FlorinF on at

Like (0)

Report

You can connect power bi on a local machine by configuring a local gateway. Look at this one: https://www.youtube.com/watch?v=tDDA58xJOUM.

I've managed to connect from powerBI.com to AX ( powerbi => AX) to get data and execute reports but not from AX to BI.

Was this reply helpful? Yes No
Ajit 8,755 on at

Like (0)

Report

Video shows how to pin the power BI report not embed the power BI report. When you pin the power BI report that can connect to any DB using gateway. You can create a Power BI report with multiple sources using gateway and that also you can pin in F&O workspace.

Was this reply helpful? Yes No
FlorinF on at

Like (0)

Report

True. But the video shows that from AX you can see and browse the reports in the PowerBi workspace. My problem is that I can not access the powerbi workspace at all. It gives me an generic error when I try to browse existing reports.

Was this reply helpful? Yes No
FlorinF on at

Like (0)

Report

How do you develop embeded power bi reports if they are not supported on dev machine ? I can't find any reference from Microsoft saying that embeded reports are not supported on dev machine.

Was this reply helpful? Yes No