Power BI Custom Refresh

Time to time, we encounter several issues while working with Data and today, I am going to explain such a scenario and it's solution.

Scenario:

In a Power BI Report, there are several tables at Data Source but when user is trying to refresh the data, it's getting failed because of one table. Now, user wants to still refresh the data for the rest of the table as this table is either not so important as of now or it will take time to fix but other tables data should get refresh.

For this type of scenarios, we can use custom refresh of the data in any Power BI report which involves following steps:

Step 1:

First of all, open the Power BI Report file and go to edit queries as shown in the following image.

Step 2.

Now, click on edit queries button and following window would open:

This window has all the required tables on the left hand side panel.

Right click on the required table and un-check the "Include in Report Refresh" option.

Step 3

Now, click on "Close & Apply" button on top left side corner as shown below

Step 4

Now, click on the refresh button on the report file. It should get work.

Please feel free to connect with me if you have any issues or problems in Power BI. Also, I would appreciate your feedback.