Forum Discussion
Behind the backend
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,
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
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.
4 Replies
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
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.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 responseThank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community supportv-prasare yes thank you
