how to publish Power BI report from D365 F&O to my workspace in Power BI

(3) Share

Report

Posted on by Jun Wang

7,440 Super User 2024 Season 2

Hi I'd like to publish a power BI report from D365 F&O to my workspace in power BI. What are the steps to achieve this? thanks

All responses (14)

Answers (3)

Jun Wang 7,440 Super User 2024 Season 2 on at

Like (0)

Report

how to publish Power BI report from D365 F&O to my workspace in Power BI

Hi Everyone, I was able to make it work after much exploring. I marked all your answers cause each provided useful information pointing me to a good direction.

Let's keep up the good work of giving and sharing.

Best

Jun Wang
Jun Wang 7,440 Super User 2024 Season 2 on at

Like (0)

Report

how to publish Power BI report from D365 F&O to my workspace in Power BI

Hi Navneeth, thanks for the reply. Right now I'm in a demo D365 F&O tenant. Is there a way to find out if it has been set up as a prod database or UAT one? could you provide more detailed steps on how to connect to the database since I'm new to this area. Your help is much appreciated.
Suggested answer

Navneeth Nagrajan 1,399 Super User 2024 Season 2 on at

Like (0)

Report

how to publish Power BI report from D365 F&O to my workspace in Power BI

Hi Juan,

For the connection part you can connect to your Tier-2 UAT environment or Tier-1 Development environment and you need to connect to the AxDW database. The AxDW database is the database you need to connect to make these reports. Before that ensure that the Deploy measures and the entity store is refreshed so that all the data is published to the AxDW database.
Jun Wang 7,440 Super User 2024 Season 2 on at

Like (0)

Report

how to publish Power BI report from D365 F&O to my workspace in Power BI

Hi I had some progress and now has powerBI reports in my LCM asset library. I downloaded a sample report and tried to open it from powerBI desktop. After entering my credentials on the Database option, I was not able to connecting to the D365 F&O database.

then I logged in D365 F&O, system administration--workspace, find the below page. which takes me to the LCM page.

I was able to view the below PowerBI reports, but don't see the deploy powerBI button.

I also tried the system parameters under system administration---setup. Not seeing how to deploy as well. Please advise if I'm on the correct page or missing any steps. Thanks!
Jun Wang 7,440 Super User 2024 Season 2 on at

Like (0)

Report

how to publish Power BI report from D365 F&O to my workspace in Power BI

Hi Layan,

The issue hasn't been resolved yet. I'm able to see a project and asset library without power bi reports. another odd thing is our IT doesn't see me in the LCS org.
Layan Jwei 7,264 Super User 2024 Season 2 on at

Like (0)

Report

how to publish Power BI report from D365 F&O to my workspace in Power BI

Hi Jun,

Is your question answered or do you still need help?
Verified answer

Navneeth Nagrajan 1,399 Super User 2024 Season 2 on at

Like (1)

Report

how to publish Power BI report from D365 F&O to my workspace in Power BI

Hi,

Steps to follow to make the report available in your workspace:

1. Ensure you have a PowerBI pro licesnse to publish the report. It looks like you don't have a PowerBI Pro license to publish to the desired workspaces.

2. Ensure that the .pbix file is added to the Asset Library from Dynamics Lifecycle Services -> Asset Library -> PowerBi report model.

3. Ensure you have the permissions to Deploy PowerBi reports from Dynamics 365 FO (System Administration -> Setup -> Deploy PowerBi Files).

Happy to answer questions, if any.
Layan Jwei 7,264 Super User 2024 Season 2 on at

Like (1)

Report

how to publish Power BI report from D365 F&O to my workspace in Power BI

Hi Jun,

In organization users, yes I'm a contributor.

If you can't see any project, then they need to add you to the project, where your name will appear in project users:

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
Jun Wang 7,440 Super User 2024 Season 2 on at

Like (1)

Report

how to publish Power BI report from D365 F&O to my workspace in Power BI

HI Layan,

Thanks for the response. Could you take a look from here and advise if your role is admin or contributor?
Layan Jwei 7,264 Super User 2024 Season 2 on at

Like (1)

Report

how to publish Power BI report from D365 F&O to my workspace in Power BI

Hi Jun,

You need to go to the asset library inside the project itself

So first, you need to look for the project and click it

then from the burger menu, choose Asset library

Then you can follow the video and the steps mentioned by Andrea

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future