Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

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.
Status: Needs Votes
Comments
ga_castroh
New Member
It would be great to have the ability to select only sources of information that require updating of a list. To improve processing times
m_busger
New Member
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.
jshanahan1
New Member
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.
kkrebs
New Member
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.
david_cornwell
New Member
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
fbcideas_migusr
New Member
David's suggestion below only works if you are using Power BI Desktop. We need similar functionality in Power BI Service
clara_pantoja
New Member
Jeff (Shanahan)'s suggestion below would be ideal. I hope it's considered in the near future
benjamin_sander
New Member
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.
mikejarod
New Member
please add
dmiradakis1
New Member
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!