Deploy Power BI reports from on premise F&O problem

[jasonyeung87]

Hi,

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 https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/configure-power-bi-int...

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:

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:

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:

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?

Jason