Schedule refresh for individual datasets within one file

[Anonymous]

Hi,

I have a desktop file with 4 datasets (all from SQL Server). I want to know if it's possible to have one dataset refresh weekly and the others refresh daily from one desktop file in Power BI Service?

For instance

Table 1 (SQL Server - Server 1) - Refresh Daily

Table 2 (SQL Server - Server 1) - Refresh Daily

Table 3 (SQL Server - Server 2) - Refresh Weekly

Table 4 (SQL Server - Server 1) - Refresh Daily

The servers are configured to one gateway connection. 

Is it possible to have this set up in power BI or will I have to set this schedule up at source (SQL)?

Thanks in advance.

A

[DebbieE · Accepted solution]

Hi @Anonymous 

If I was doing this I would probably create them seperately as dataflows in service. have them scheduled in the way you have mentioned. then connect all of the dataflows into a shared dataset in the pbix file

[Anonymous]

Hi @DebbieE 

Thank you for your response. 

Apologies in advance for this next question, I'm fairly new with data flows in Power BI. 

Do I need to schedule the PBIX file still even if the dataflows are on a schedule refresh?

Thanks in advance.

Regards,

A

[DebbieE]

Apologies, Ive been on annual leave and missed your response. I think both a dataflow and dataset need data to be refreshed

https://community.powerbi.com/t5/Service/Dataflow-vs-Dataset-refresh/td-p/572076

Its one Id like to have a look at in a bit more detail. I leave half an hour between mine but I would like to schedule them properly