refresh only one data source out of several
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.
jose valdes commented
check box "Include in report refresh" only works in desktop. I have the problem in power bi service.
Ellie Nguyen commented
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.
It's already more than 3.5 years and still this feature is not implemented, Surprised !!!
This is a vital requirement as often i want to refresh only specific queries which has been modified and not others.
João Carlos dos Santos commented
Refresh in separate "querys" is an essential feature. I do not know why Power BI does not allow this. It is of extreme necessity.
Manually refresh one data source out of several and set the schedule time separately
Daniel Miradakis commented
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.
Ben Sanders commented
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.
Jeff (Shanahan)'s suggestion below would be ideal. I hope it's considered in the near future
Nishant Jain commented
David's suggestion below only works if you are using Power BI Desktop. We need similar functionality in Power BI Service
David Cornwell commented
I just found the solution (it exists already but is not as intuitive as if it was available via the Refresh button).
Kerri Krebsbach commented
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.
Jeff Shanahan commented
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.
While looking for the option to do this, I found out it is possible to remove certain tables from the refresh in the query editor. This done by right clicking on the table in the query editor and deselect the "Include in report refresh" option. I hope this helps others who are having the same problem.
It would be great to have the ability to select only sources of information that require updating of a list. To improve processing times