Forum Discussion

Jhonrey4's avatar
Jhonrey4
New Member
11 months ago
Solved

Power BI Report Server Schedule Refresh Error

In the report server database est connection is successful but whenever doing schedule refresh its not connecting. throwing error like "an error occurred within the report server database. this may b...
PowerBI Report Server
  • vivien57's avatar
    vivien57
    11 months ago

    Hello Jhonrey4 ,

    After your IP address, you can put ":" and the port number in the server information.

    Please feel free to give me a kudo

    Have a nice day,

    Vivien

Jhonrey4's avatar
Jhonrey4
New Member
11 months ago

I am not been able to refresh it since this is the first Power BI to be deployed in the Report Server. and I am not really familiar in On-Prem report server. Based on my initial research can you confirm if the server need SQL Server Analysis Services (Power BI mode) in the services because I cannot see it and I think this is not installed in our server.

vivien57's avatar
vivien57
Super User
11 months ago

No, if your data source is a relational SQL Server database, you do not need to install Analysis Services.

The error message mentions Analysis Services (or AS) because the underlying engine that stores the data model on Power BI Report Server is similar (but it is embedded in the .PBIX file), so there is no need to install it on the server side.

Have you tried my previous recommendations? Can you send a screenshot of the data source configuration in Power BI Desktop?

Are you sure you have the version of Power BI Desktop for Report Server? (And not the one for Power BI Service)

https://www.microsoft.com/en-us/download/details.aspx?id=106034

Please feel free to give me a kudo and/or accept my answer as the solution if it suits you.

Have a nice day,

Vivien