Power Query Power BI - Transform 2 Fact Tables to Star Schema Data Model - Invoice Data

Power Query Power BI - Transform 2 Fact Tables to Star Schema Data Model - Invoice Data

Learn how to transform two fact tables (Header Invoice and Invoice Line Item) with dimension tables into a proper Star Schema using Power Query in Power BI Desktop. Master techniques for importing non-Star-Schema models, transforming tables with custom columns and merges, and loading a Star Schema model into Power BI Data Model. Explore solutions for header-detail granularity reporting issues, invoice level mismatches, and allocating invoice totals to detail levels. Follow step-by-step instructions to create measures, establish relationships, and build visualizations that leverage the newly created Star Schema data model.