Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

On Prem Report Server not updating/refreshing reports

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's avatar
    Anonymous
    8 years ago

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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous,

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable

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

      • Anonymous's avatar
        Anonymous
        Not applicable

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