Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Report does not refresh on schedule

I've worked with several experienced Power BI developers here at work to find a solution for this issue. So far, we haven't been able to resolve. I've searched and tried all the suggestions in this c...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

If your dataset contains not only Sharepoint data source but also the premise data source, then it is necessary to use an on-premise gateway and configure schedule refresh. For further information, please refer On-premise data gateway , Configure scheduled refresh .

Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-alq-msft 

     

    The Sharepoint that has the Excel file isn't on-premise. The file refreshes with no error or problem with Power BI Desktop. That was the first thing I checked and as noted, the more experienced developers here tried several solutions. They are stymied and think the issue likely the Power BI is online.

     

    I was curious if anyone else had the same issue and any ideas on what to check we hadn't thought about.