Thursday, July 15, 2021

Power BI - How to refresh single table from data model

Issue: When we click on Refresh button to refresh the table(s) in Power BI Designer, by default, it will start refreshing all the tables in the data model. Sometimes, we may need to refresh only 1 or 2 tables instead of complete Data Model.  Refreshing complete data model is a time consuming process depends on volume of data & unnecessary utilization of CPU, I/O & memory if complete data model refresh is not required. To avoid such refresh issue, Power BI provides a way of refreshing table individually.

Steps to refresh table individually:

      1) Open the Power BI Designer

      2) Right click on the table which need to refresh. Click on Refresh.


          3) It will start refreshing the table


No comments:

Post a Comment