Forum Discussion
Schedule Refresh Power BI Report Server
can i schedule power bi report on report server ( on - premises) ?
what is the frequency i can schedule like daily, weekly or monthly etc?
can i schedule report using direct query?
Hi powerbiexpert22 - Yes, you can schedule Power BI reports. coming to the second question,
When scheduling data refresh or subscriptions, you can use the following frequencies:
Daily
Weekly
Monthly
Specific days of the week
Multiple times per day
by defining starttime and endtime, repeat frequency of interval.
coming to the last question, No, you cannot schedule refresh for DQ, as you know directQuery always queries the data live when a user views the report.Therefore, scheduling a refresh doesn't apply — there's no data cache to refresh.
reference links:
Configure scheduled refresh - Power BI | Microsoft Learn
Schedule Refresh Dataset or Reports in Power BI Report Server | Security of Reports and Folders
Hope this helps.
powerbiexpert22 Hey,
You can follow below step to fulfill your requirement.1. Scheduling Power BI Reports on Power BI Report Server (On-Premises)
Power BI Report Server allows you to schedule report refreshes and email subscriptions. Here’s how it works:How to Schedule Reports:
Step 1: On the Power BI Report Server portal, go to the report you want to schedule.Step 2: Select the report and click on Manage.
Step 3: Under Subscriptions, you can add a new subscription to schedule the report.
Step 4: Configure the subscription by selecting the frequency, time, and recipient for the scheduled report (email, file, etc.).
Frequency Options for Scheduling Reports:
You can set the frequency of the report refresh based on your business requirements. The available frequency options include:Daily: Refresh the report every day at a specific time.
Weekly: Refresh on specific days of the week (e.g., Monday, Wednesday, Friday).
Monthly: Refresh on specific days of the month.
One-time (Ad-Hoc): Refresh at a specific date and time.
These frequencies can be configured within the Subscription Settings for the report.
Thanks
Harish M
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
7 Replies
Hi powerbiexpert22 - Yes, you can schedule Power BI reports. coming to the second question,
When scheduling data refresh or subscriptions, you can use the following frequencies:
Daily
Weekly
Monthly
Specific days of the week
Multiple times per day
by defining starttime and endtime, repeat frequency of interval.
coming to the last question, No, you cannot schedule refresh for DQ, as you know directQuery always queries the data live when a user views the report.Therefore, scheduling a refresh doesn't apply — there's no data cache to refresh.
reference links:
Configure scheduled refresh - Power BI | Microsoft Learn
Schedule Refresh Dataset or Reports in Power BI Report Server | Security of Reports and Folders
Hope this helps.
Hi rajendraongole1 ,
are you referring to power bi report server or power bi service? my question is for power bi report server ( on premises)
I am referring PBI Server, Yes, you can schedule data refreshes for reports hosted on Power BI Report Server but only for reports using Import mode (i.e., data loaded into the PBIX file, not DirectQuery).
Hope this works.
powerbiexpert22 Hey,
You can follow below step to fulfill your requirement.1. Scheduling Power BI Reports on Power BI Report Server (On-Premises)
Power BI Report Server allows you to schedule report refreshes and email subscriptions. Here’s how it works:How to Schedule Reports:
Step 1: On the Power BI Report Server portal, go to the report you want to schedule.Step 2: Select the report and click on Manage.
Step 3: Under Subscriptions, you can add a new subscription to schedule the report.
Step 4: Configure the subscription by selecting the frequency, time, and recipient for the scheduled report (email, file, etc.).
Frequency Options for Scheduling Reports:
You can set the frequency of the report refresh based on your business requirements. The available frequency options include:Daily: Refresh the report every day at a specific time.
Weekly: Refresh on specific days of the week (e.g., Monday, Wednesday, Friday).
Monthly: Refresh on specific days of the month.
One-time (Ad-Hoc): Refresh at a specific date and time.
These frequencies can be configured within the Subscription Settings for the report.
Thanks
Harish M
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your queryHi powerbiexpert22 ,
I wanted to check if you had the opportunity to review the information provided by rajendraongole1 and HarishKM . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi powerbiexpert22 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi powerbiexpert22 ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
