Enterprise financial models in Power BI need a star schema
A flat Excel sheet dropped on the canvas does not survive real financial reporting. Here is what I do in Power Query and the model layer instead: profile the columns, reference rather than duplicate, build a dynamic date table, and keep relationships single-direction.