I have previously been able set up a scheduled refresh for my Power BI reports. However, in my newest report I do not have the same option. Is there a way for me to fix this issue?
1 Like
Hi,
When you build your Power BI file from Power BI Desktop you can select many different datasources. Sometimes you select one source other times multiple different sources.
Let’s pretend you have built a report based upon SQL Connection (connection type set as SQL Connection) and you have also set that the data should be imported. Then your report is by Power BI flagged to be ‘Refreshable’.
When VAP see ‘Refreshable’ flag is on we show two icons on manage file list view. Now you can trigger OnDemand refresh or set up a refresh plan to run when you like to import new data into the report.
If your report is not set to be refreshable by Power BI VAP will not show these two icons. This may occur if you have your datasource file on your local drive where Power BI do not have access to read and upload fresh data.
When you click OnDemand the refresh starts, and the icon become black. Each time a refresh is done history is kept by the dataset for that report in Power BI workspace. You can see the result of refreshes when Power BI services have completed the refresh, by clicking the clock.
A refresh will remove all data from all tables and reload it from the data source, so it’s a memory costly feature. System Admin user access ‘Configure’ to set up refresh plan and associate it to one or several refreshable reports.
2 Likes