Disable data load in power query editor

Anonymous 

Hi, 

Even if a query is unchecked for load and refresh, the semantic model still holds a reference to the source table especially if you're using DirectQuery or Composite Model, or the query is used in a relationship/downstream reference, Or, the model schema still knows about that table’s structure.

Power BI doesn’t cache or isolate the schema by default, so if your Databricks table changes, Power BI reflects those schema changes, even if it doesn't reload the data.

That being said, instead of connecting directly to a live or frequently updated table in Databricks, you may 

• Create a snapshot or staging table in Databricks that holds a static version of the data.
• Connect Power BI to this static table.
• Only update this table manually when you want changes to reflect in Power BI.

You can run this in a Databricks SQL notebook or SQL Editor if it is an one-time copy, 

CREATE OR REPLACE TABLE database.snapshot_table
AS
SELECT * FROM database.source_table;

This will give you full control over when changes are visible.

Hope this helps:)