Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi there,
We have published one report to power bi report server. When we refresh the report manaully, it is getting refreshed in a minute, whereas when we enable schedule refresh for the same report, it is failing consistently.
We are using October'17 version of Power BI Report server.
Data Source: SQL Server (Import)
When we check the power bi report server log file, below is the error:
Hi @sgovindarajula,
Based on my test in the latest Power BI report server version 14.0.600.442, the schedule refresh can be completed successfully.
1. Which Power BI report server version did you run? Please update to the same version as ours.
2. Please download and install corresponding Power BI desktop optimized for report server version then open the report, republish to report server.
3. If above ways don't work, please share detail information with us. For example, do you specify any T-SQL query when getting data; do you do any Merge/Append Queries steps after importing data,etc.
Best Regards,
Qiuyun Yu
Hi @v-qiuyu-msft,
We are using the October 2017 Power BI Report Server version. The PBI refresh works manually where as in report server it is failing.
Below are the steps which we have done to overcome this issue:
By doing the above 2 steps, we would able to fix the refresh issue in Report Server. In other terms, we have ensured to keep our data model simple without making any modifications in the Power BI ( Like Merge/Append)
- S
User | Count |
---|---|
4 | |
4 | |
2 | |
2 | |
2 |