Forum Discussion

sgovindarajula's avatar
sgovindarajula
Frequent Visitor
8 years ago

Scheduled Data Refresh failing in report server

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 re...
Report Server
Schedule Refresh
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

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 

sgovindarajula's avatar
sgovindarajula
Frequent Visitor
8 years ago

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:

 

  1. Getting rid of Merge/Append queries in Power BI and handling them in the SQL ( which is our data source)
  2. Getting rid of, Custom Column which we have created  in one of the data set

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