Updating specific tables only

[Anonymous]

Hi, I have a bunch of tables in my report, but when i make a change one table, the others start updating whether I want them to or not.
What is the best solution if you just want to do something like add a new sql data source, but don't anything else updated in the report? 

[dadb25 · Accepted solution]

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!

[amitchandak · Accepted 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?

[Anonymous]

Thanks for your help.

[Anonymous · Accepted solution]

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

[Anonymous]

This was a good suggestion and thanks for your help!

[Anonymous]

Thanks Wisdom.  I'll try it out.

[amitchandak · Accepted 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?

[dadb25 · Accepted solution]

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!