A fact table stores measurable business data such as sales, revenue, transactions, or quantities, while a dimension table stores descriptive information like customer details, product names, dates, or locations that provide context to the facts. In data modeling and Microsoft Power BI reporting, fact tables are used for analysis and calculations, while dimension tables enable filtering, grouping, and drill-down reporting.