Forum Discussion
Power BI Report Server Schedule Refresh Error
Hi Vivien,
My data source is SQL Server.
Below is the image of RAM and disk space of the Report Server and the count from Event table is 0.
For the IsDataModelRefreshService in rsreportserver.config, it is set to true.
Have you ever been able to refresh it, or did it work and now it doesn't?
Otherwise, you can try the following:
- Specify the port in your connection
- Enter the IP address rather than the server name
- Check the connector you are using (can you share with us how you configured the DataSource in your PBIX file)
Please feel free to give me a kudo
Have a nice day,
VivienI 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.
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
Hi Vivien,
Please see below my connection. Can I ask how to specify the port in the connection?