Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I want to understand how much data gets stored in PowerBI , when a user acts on reports (applying filters etc..), dashboard or refreshes a dataset.
Consider a report is based on tabular model, and another report based on datasource (which does nto support direct query)
@sitandon You can find all the information you need in the security white paper. It breaks down how things are stored and how direct query is different. You can find the download link here
In a nutshell, Tabular model and Direct Query don't store the data in the cloud - they use DAX to pull the relevant info and only cache what is needed temporarily. The other datasets have all the information pulled up into Azure and stored for use.