Skip to main content

    Power BI

    Needs Votes

    refresh only one data source out of several

    Vote (458) 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

    João Carlos dos Santos 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

    Power BI User 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

    Bikash Deb's profile image Profile Picture

    Daniel Miradakis on 05 Jul 2020 23:43:04

    RE: refresh only one data source out of several

    Please add this functionality. While you can combine multiple data sources (with different refresh frequencies) from multiple .pbix files into one Dashboard in the Power BI Service, it would sometimes be ideal to combine these several data sources into a Report instead of a Dashboard - for instance, a report has Bookmark functionality while a Dashboard does not, and I may need to utilize Bookmarks when consolidating several of my data sources.

    Thank you!

    Bikash Deb's profile image Profile Picture

    Mike on 05 Jul 2020 23:41:46

    RE: refresh only one data source out of several

    please add

    Bikash Deb's profile image Profile Picture

    Ben Sanders on 05 Jul 2020 23:36:12

    RE: refresh only one data source out of several

    It would also be really nice to be able to update a Group of Data Sources. Ie if there are 5 data sources and 2 of them only need to be updated monthly, but the other 3 need to be daily, it would be nice to be able to designate refresh groupings instead of refreshing each table individually.

    Bikash Deb's profile image Profile Picture

    Clara on 05 Jul 2020 23:32:25

    RE: refresh only one data source out of several

    Jeff (Shanahan)'s suggestion below would be ideal. I hope it's considered in the near future

    Bikash Deb's profile image Profile Picture

    Nishant Jain on 05 Jul 2020 23:21:40

    RE: refresh only one data source out of several

    David's suggestion below only works if you are using Power BI Desktop. We need similar functionality in Power BI Service

    Bikash Deb's profile image Profile Picture

    David Cornwell on 05 Jul 2020 23:18:35

    RE: refresh only one data source out of several

    I just found the solution (it exists already but is not as intuitive as if it was available via the Refresh button).
    https://community.powerbi.com/t5/Desktop/REFRESH-A-TABLE-IN-POWER-BI-DESKTOP/td-p/232856

    Bikash Deb's profile image Profile Picture

    Kerri Krebsbach on 05 Jul 2020 23:14:26

    RE: refresh only one data source out of several

    Also add order of refresh. This would allow one data source to be refreshed, and possibly build tables' data, and the next to use that built data in a summarization query.

    Bikash Deb's profile image Profile Picture

    Jeff Shanahan on 05 Jul 2020 23:00:14

    RE: refresh only one data source out of several

    Ideally we could manage this from the Power BI Service Gateway/DataSet settings. Choose to "include in report refresh" only the data sources we wish, and for the other data sources just maintain the existing published data in the DataSet.