Forum Discussion
Dataflow used On-Premise - Can't schedule refreshes
- 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.
Ok, now it's getting better. You should be able to schedule the power bi dataset without any isse because its source is a dataflow.
Regarding dataflow, which sources are you getting data from? is this the component you can't schedule?
Hopefully the screenshot will help. Data Sources is disabled because it doesn't recognize the dataflow. My question is, should it? It's set to Import.
- ibarrau5 years ago
Super User
That doesn't look like Power Bi Service. That looks like Power Bi Report Server hahaha.
Is that Power Bi Report Server?I don't know much about it but I can move the post to the respective forum.
Regards
- jcampbell4745 years ago
Helper IV
Correct, it is on-premise. Wasn't sure where to post since dataflows are in the service and the app is on RS.
Thank you for relocating it to the appropriate area.