Where is the data stored in Power BI?
Primarily, Power BI has two sources to store data :
Azure Blob Storage : When users upload the data, it gets stored here.
Azure SQL Database : All the metadata and system artifacts are stored here.
They are stored as either fact tables or dimensional tables.