Skip to main content
Microsoft Idea

Power BI

Needs Votes

refresh only one data source out of several

Vote (442) Share
Bikash Deb's profile image

Bikash Deb on 08 May 2016 04:21:13

If you have multiple sources of data, with some large and small it would be ideal if you could just refresh one source (small) so it speeds up the process of updating the dashboard massively.

Comments (32)
Bikash Deb's profile image Profile Picture

Manson Lam on 29 Apr 2024 07:38:16

RE: refresh only one data source out of several

I have a python script that would like to refresh quarterly and the semantic model is connected two 3 other sources. Since python needs to be run with gateway, I do not want to keep my computer on. Desktop version has the choice to stop loading for certain tables. I hope power BI web can also provide such option!!!!!

Bikash Deb's profile image Profile Picture

Krid Dusitsin on 28 Feb 2024 07:36:02

RE: refresh only one data source out of several

It would be nice to have this feature. My data sources are from SQL databases and Excel files. The data in Excel files are quite static so there is no need to refresh the data in Excel. Also, it is quite a hurdle for me to place these Excel files at a location where the BI Gateway can access.

Bikash Deb's profile image Profile Picture

Sagar Subedi on 25 Sep 2023 04:32:31

RE: refresh only one data source out of several

This is a much needed feature. Would appreciate it's addition.

Bikash Deb's profile image Profile Picture

BW WONG on 08 Aug 2023 17:16:30

RE: refresh only one data source out of several

This is a crucial feature when bandwidth is restricted per refresh. This prevents updating the sources one by one manually. Please add this feature as soon as possible. A checklist where we can select data sources to refresh is all we want.

Bikash Deb's profile image Profile Picture

Ivan Georgiev on 20 Mar 2023 10:44:25

RE: refresh only one data source out of several

This is a much needed feature!

Bikash Deb's profile image Profile Picture

Ashlyn Campbell on 20 Jun 2022 16:21:41

RE: refresh only one data source out of several

Required for refreshing new datasets only, and leaving old datasets not refreshed.

Bikash Deb's profile image Profile Picture

Saumyadip Sarkar on 31 Mar 2022 07:16:20

RE: refresh only one data source out of several

Badly need this feature. Else, the purpose of having multiple connections is lost.

Bikash Deb's profile image Profile Picture

Alicia Alcaide on 16 Feb 2022 18:04:57

RE: refresh only one data source out of several

I'm having issues with this because I have a dataset with two different connections, BigQuery and Excel. And I have configure that I don't want to refresh the table from the Excel file but anyway, when I publish it to Power BI Service, if the gateway is turned off I can't refresh the whole dataset. I doesn't make sense!

Bikash Deb's profile image Profile Picture

Gastón Luis Tello Fernández on 13 Jul 2021 16:56:18

RE: refresh only one data source out of several

Only 10% of my data needs hourly refresh, the rest is weekly. I cannot schedule the hourly refresh because the 90% portion of data that I don't need takes more than an hour to update.

Bikash Deb's profile image Profile Picture

Paul Middleton on 16 Jun 2021 16:27:18

RE: refresh only one data source out of several

Definitively needed. Any single data source refresh or at least single refresh for related data sources ( two merged tables to make a 3rd would of course have to all be refreshed at once). It's just not very efficient from either side to have to refresh all data sets in a Power BI Desktop File.