On Prem Report Server not updating/refreshing reports

[Anonymous]

Hi Experts

Can see the wood for the trees....

If I go to the ‘Scheduled refresh’ section of a report in the Power BI Report Server, I get the following message:

 

Looking into this further, Scheduled Data Refresh is not possible for the following:

• Your report contains one or more Analysis Services data sources, which use a live connection. - Nope
• Your report contains one or more data sources, which use DirectQuery. – Nope. I believe we’re using Import Mode
• Your report does not contain any data source. For example, data is manually entered via Enter Data or a report contains only static content like images, text, etc. – Nope
• Where Import Mode is used:
  • If a File or Folder data source is used and the file path is a local path (e.g. C:\Users\user\Documents), then a refresh plan cannot be created. The path must be a path the report server can connect to like a network share. For example, \myshare\Documents. – Nope
  • If data source can be connected using only OAuth (e.g. Facebook, Google Analytics, Salesforce, etc.), then cache refresh plan cannot be created. At the moment, RS does not support OAuth authentication for any data source whether it is for paginated, mobile or Power BI reports. – Nope

[Anonymous]

Hi @Anonymous,

What is your data source type? Can you refresh the data in PBI Desktop?

[Anonymous]

Data source type is SQL and yes to the refresh on PBI Desktop.......

[Anonymous · Accepted solution]

Can you share a screenshot of the data sources tab for your report from the Report Server portal?