CODEWITHSUNDEEP
powerbipower-bi-report-server
GregS_SDBA
GregS_SDBA

Reputation: 130

Power BI Queries with Data Not Used in Visual

Will Power BI still query data if the data is not used in a visual? The model and data source are still technically there but if it's not actively used does the data still get pulled?

Upvotes: 0

Views: 94

Answers (1)

Peter
Peter

Reputation: 12335

If you are using IMPORT MODE: Yes, the data is completely pulled into the data model and RAM, no matter if it is used to calculate a visual or not.

If you are using DIRECT MODE: No, only the data needed for the visualizations (this includes slicers) is pulled into memory.

Read the docs: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

Upvotes: 1

Related Questions