When data is ingested in Power BI, it is basically stored in Fact and Dimension Tables.
Fact Tables: The central table in a start 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 that are stored in a fact table