Where is data stored in Power BI?
When data is ingested into Power BI, it is basically stored in Fact and Dimension tables.
* Fact tables : The central table in a star schema of a data warehouse, a fact table stores quantitative information for analysis and is not normalized in most cases.
* Dimension tables : It is just another table in the star schema that is used to store attributes and dimensions that describe objects stored in a fact table.