Skip to main content

Power BI

Needs Votes

refresh only one data source out of several

Vote (243) 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 (20)
Bikash Deb's profile image Profile Picture

fa4ee2a0 a628-4221-b69f-08cd49b2b3ff on 06 Jul 2020 00:16:18

RE: refresh only one data source out of several

Would be very useful - I need to make minor updates in smaller data sources. But this is always problematic since there's a large data source which takes about 1/2 hour per refresh.

Bikash Deb's profile image Profile Picture

6c5bed83 cf7f-4b61-bdbe-6551f518b113 on 06 Jul 2020 00:10:00

RE: refresh only one data source out of several

need a feature to schedule refresh rate for different data sources. Some large source only need a weekly refresh whether small one need hourly refresh.

Bikash Deb's profile image Profile Picture

5d79b871 cfca-43ea-bdcf-f23ea67921ef on 06 Jul 2020 00:09:29

RE: refresh only one data source out of several

it will be very useful when Power BI develop this improvement

Bikash Deb's profile image Profile Picture

1e26830d 19d1-4196-a6b5-01e3270643d6 on 06 Jul 2020 00:05:50

RE: refresh only one data source out of several

It's just a shame that Power BI doesn't allow to select sources to update... It makes the refresh feature useless for the most of my reports.

Bikash Deb's profile image Profile Picture

74696771 3b30-4ce3-aac6-10aea8136b04 on 06 Jul 2020 00:01:58

RE: refresh only one data source out of several

check box "Include in report refresh" only works in desktop. I have the problem in power bi service.

Bikash Deb's profile image Profile Picture

7d580566 4ffa-4d3c-bc78-c4ba3e932d1a on 06 Jul 2020 00:01:52

RE: refresh only one data source out of several

If you right click each of the data source in Edit Queries window, there should be a check box "Include in report refresh" where you can decide whether or not to refresh that source.

Bikash Deb's profile image Profile Picture

8ab5bc5c fec4-4a37-bb66-fe0039101f90 on 06 Jul 2020 00:01:44

RE: refresh only one data source out of several

It's already more than 3.5 years and still this feature is not implemented, Surprised !!!

Bikash Deb's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:59:00

RE: refresh only one data source out of several

This is a vital requirement as often i want to refresh only specific queries which has been modified and not others.

Bikash Deb's profile image Profile Picture

d5595f1f 011e-403f-9b16-6c070d93fcf3 on 05 Jul 2020 23:49:53

RE: refresh only one data source out of several

Refresh in separate "querys" is an essential feature. I do not know why Power BI does not allow this. It is of extreme necessity.

Bikash Deb's profile image Profile Picture

78b65a9c ef0d-46d0-b6ef-b5515c4f06c7 on 05 Jul 2020 23:49:45

RE: refresh only one data source out of several

Manually refresh one data source out of several and set the schedule time separately