Forum Discussion

jcampbell474's avatar
jcampbell474
Icon for Helper IV rankHelper IV
5 years ago
Solved

Dataflow used On-Premise - Can't schedule refreshes

We have a dataflow feeding an app to be used on-premise.  It refreshes fine in desktop.  But once it's uploaded to the on-site server, scheduled refresh isn't available.     Here is the message: Sc...
  • Icey's avatar
    Icey
    5 years ago

    Hi jcampbell474 ,

     

    It is not supported to create scheduled refresh for Power BI dataflows in Power BI Report Server.

     

    You can find here that when data source is on Power BI Service, it is not supported to set scheduled refresh,

     

    Data source Cached data Scheduled refresh Live/DirectQuery
    Power BI service No No No

     

     

    In additions, here are some scenarios where scheduled refresh cannot be configured:


     

    Not all Power BI Reports can have a scheduled refresh plan created on them. The following is a list of Power BI Reports that you Can't create a scheduled refresh plan.

    • Your report contains one or more Analysis Services data sources, which use a live connection.
    • Your report contains one or more data sources, which use DirectQuery.
    • 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.

    In addition to the above list, there are specific scenarios with data sources in import mode, for which you cannot create refresh plans.

    • 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.
    • 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.

     

    Reference: When scheduled refresh can't be used

     


     

    Best Regards,

    Icey

     

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