Behind the backend

[ahmedshalabyy12]

Dears,

I’m using Power BI Desktop in Import Mode with a Databricks normal view as the data source. The setup applies incremental refresh, where only the last month is refreshed, and the previous two years are archived.

My question is:
When users query the report from the Power BI Service, will it hit the Databricks source every time, or will the data already be stored in the capacity as an imported copy, preventing the report from repeatedly querying Databricks (which could slow performance due to the normal view hitting the physical data)?

FYI : Iam using query folding  

Thank you,

[FBergamaschi · Accepted solution]

in Import mode, you do not query the source but use the imported data

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[v-prasare]

Hi @ahmedshalabyy12,

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

@Shahid12523 & @FBergamaschi ,Thanks for your prompt response

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

[ahmedshalabyy12]

@v-prasare  yes thank you

[Shahid12523 · Accepted solution]

No, Databricks is not queried every time.
Since you're using Import Mode with incremental refresh, the data is stored in Power BI’s internal storage. Users query the cached data, not Databricks—except during scheduled refreshes, which only pull the latest month thanks to query folding.

[FBergamaschi · Accepted solution]

in Import mode, you do not query the source but use the imported data

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI