Updating specific tables only

Hi Anonymous ,

Don't know if I really get your concern, but you can try this :

If you have load your dataset, and you are sure you don't need any refresh on it, select your query and on the top right side click on All Properties :

and unclick the check box "Include in report refresh".

Then, it will never refresh this table.

Regards

Did I answer your question? Mark my post as a solution!

Anonymous , If the changes are done in power query, it will load all dependent tables too. 
Are these tables using that table in the calculation?

Hi Anonymous ,

If I understand correctly, the issue is that you want to update only specific tables. Please try the following methods and check if they can solve your problem:

1.Select Get data > SQL Server.

2.Select the tables you want to add to the report.

3.Select load to add the data directly.

4.Under File > Options and settings > Options > Data load, disable the Auto Date/Time feature.

5.After publishing the report to the Power BI Service, adjust the refresh settings to exclude the new tables.

Best Regards,

Wisdom Wu