Separating daily Actual Data refresh from once-a-month Budget file upload

[Anonymous]

Hello friends,

Need your help with this simple and common scenario:

My model combines two facts: Actual and Budget

Actual is built from API data source and should be refreshed daily (or by "Refresh Now")

Budget - is taken from GoogleDrive Excel file. It changes very rarely (once a month or two)

So, I don't want my queries to actually refresh data from the Budget file each time when the Refresh is run.

(The reason is that it takes time and also that the Google Drive connection fails from time to time - it's annoying since I don't really need it to refresh)

When the budget changes - I am OK with some special simple manual refresh.

Any ideas?

Thanks a lot!

Michael

[tringuyenminh92]

Hi @Anonymous,

Cause googled rive is for storing and sharing purpose, so I recommend you to move the Budget file to Azure storage blob and let Azure takes care it. You could upload new budget file each month when need to update new configuration.

[Anonymous]

So the Schedued Refresh in Powerbi.com wouldn't actually refresh the Budget fact in the data model if it's source is Azure blob and the file hasn't changed?
I don't see how is it different from Powerbi.com service perspective
Thanks

[tringuyenminh92]

I think no @Anonymous, cause the refreshing mechanism is correct as @Seth_C_Bauer said, but the connection to Azure blob will not failed like google drive, cause it could handle connection request as much as you want. My suggestion does not solve your gap in refreshing schedule, it just move it to Azure blob to prevent failed case happens.

[Anonymous]

Ok. Got it. Thanks for that.
It would be nice thought if you could schedule/trigger different queries separately.
Sort of mini etl flow manager

[v-yuezhe-msft]

Hi @Anonymous,

An idea about refreshing specific data source in a dataset has been submitted in the following link, please vote it to help Power BI team prioritize this feature.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9858360-refresh-specific-data-source

Thanks,
Lydia Zhang

[Anonymous]

Actually, maybe I've found a way?

When right-click a query in desktop - There is "Include in report refresh" check box.

Maybe it'll do the job?

Has anyone tried?

[tringuyenminh92]

Hi @Anonymous,

Yes, this is the feature I thought when i read this topic, so i have created one report with 2 table from sql server and uncheck include in refresh for one table. after that i published report and checking by remove some rows in that table, but the refreshing was coming with new changes.

[Seth_C_Bauer]

@Anonymous I am not aware of any way to control refresh on specific data sources in a dataset. The current refresh functionality is "all or nothing".