SQL Data Refresh

[MateusStefani]

My powerBI is connected to two SQL database. One is old and should never be refresh, the other should refresh daily. Both database have the same tables and I combine the similars one before upload to the model (eg. sales, production, tranport tables). How do I prevent the old SQL tables to update when I hit "refresh" on powerBI?

The queries are already disable for upload and update report refresh in Power Query. 

Thank you!

[danextian]

Hi @MateusStefani 

Combining the old and new database tables in the query editor will still include the old ones in the refresh. To exclude the old tables from the refresh, load them separately and uncheck Include in report refresh for each query. You can use relationships and measures to visualize the old and new tables together.

[ribisht17]

hi @MateusStefani 

Please check this one Solved: Disable refresh for particular table in power bi - Microsoft Fabric Community 

Regards,

Ritesh

Please mark the answer if it is helpful so that it can help others as well

Dance-Sing with Data Projects - YouTube

[lbendlin]

It's nigh impossible to "not include in refresh"  when there is lineage.

You could load the tables from the old SQL database into a dataflow and then not refresh the dataflow.  You will still have to load from the dataflow into the semantic model on each refresh, so if you consider Occam's Razor this is a futile extra step unless your old database is either slow or going away soon etc.

What you can consider is the enhanced Refresh API - it allows you to selectively refresh individual tables in your semantic model - and even individual partitions if you have these.

Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn