Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Deploy Power BI reports from on premise F&O problem


I have an on prem F&O environment and want to deploy Power BI reports. The following link provides me instructions on how to do this

I've followed the steps in the link and also installed a data gateway on the server (as it's on prem). After setting this up, I tried to deploy a Power BI report (these reports are prebuilt), via the following:

Deploy Power BI.JPG

I checked one of the reports and then clicked on "Deploy Power BI files" on the top left corner. It would process for a while and then fail with the following message:

Deploy Power BI failed.JPG

While this is processing, I logged onto Power BI service, went to the "My workspace" workspace and noticed that the report I'm deploying is in the workspace, but will disappear when F&O fails. I opened the Power BI file and it has the error message at the top:

Error in Power BI report.JPG

When I setup the data gateway in Power BI service, I was able to connect to the database. (user is "axdwadmin" and the database is "AXDW").


I was wondering if there is some additional info on how to allow F&O to deploy Power BI reports?





Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.