Skip to main content

Power BI

New

Allow a local refresh of just one table instead of having to refresh all tables every time.

Vote (83) Share
Power BI User's profile image

Power BI User on 26 Sep 2015 04:49:02

This would be helpful in the online version as well. I often have to add fields in order to make the relationships work with my reports (they do not always seem to understand the relationship between objects.) As a result, I need to add new columns. Each time I do this I have to refresh the entire dataset which is painstakingly slow. Can you please allow us to refresh just one table at a time?

Comments (6)
Power BI User's profile image Profile Picture

d59cd51f 2363-40a3-95f3-3d213b3decde on 06 Jul 2020 00:07:15

RE: Allow a local refresh of just one table instead of having to refresh all tables every time.

I would love to have this feature too. It's annoying that you have to refresh the full dataset in the service or download it and refresh the one table you need from power BI desktop then republish it.

If they can give the same feature to refresh a single table in the model in Power BI desktop available on Power BI service as well it will save alot of development time.

Power BI User's profile image Profile Picture

add10df8 00d4-4adc-b28e-5707b4fda5c7 on 05 Jul 2020 23:00:13

RE: Allow a local refresh of just one table instead of having to refresh all tables every time.

Solved:
http://community.powerbi.com/t5/Desktop/REFRESH-A-TABLE-IN-POWER-BI-DESKTOP/td-p/232856

Power BI User's profile image Profile Picture

bbe7bb93 fc07-44c5-84e2-7a776cf44272 on 05 Jul 2020 22:56:12

RE: Allow a local refresh of just one table instead of having to refresh all tables every time.

if you go to the datasource, select the table you want to refresh, edit configuration, add a space that wont change the result of the query and Acept... that will refresh that table only... the apply the change and the refresh will impact the report.

Power BI User's profile image Profile Picture

4457152c 6c22-422d-a4be-d36af1087b41 on 05 Jul 2020 22:55:44

RE: Allow a local refresh of just one table instead of having to refresh all tables every time.

This will be great and help to eliminate unnecessary object refresh

Power BI User's profile image Profile Picture

6e5fc3dd 1b0b-4ebe-aff4-1c7a8c95dedf on 05 Jul 2020 22:44:06

RE: Allow a local refresh of just one table instead of having to refresh all tables every time.

Absolutely. For users its not a biggie but for development, where you might be identifying and adding individual row in a dimension table, it's critical.

Power BI User's profile image Profile Picture

aa238d5d a65a-4f39-8d8a-86abd3e4f10d on 05 Jul 2020 22:29:44

RE: Allow a local refresh of just one table instead of having to refresh all tables every time.

This would be a great function....like in Power Pivot where you can select and refresh a single table rather than the whole data set....can be a pain dans la derriere!