Power Bi Report Loading Slow (Performance Issue on the Report Loading)

[Anonymous]

Hi Team,

i have been facing an issue with the Power BI report, performing slow which is having the matrix/Table visual.

 when verifying the data model i see i have couple of fact tables among which i have observed there are two fact tables one is Factsales and other is Salescount which is having a inactive relationShip  with cardinality many to many and the column related is Salecode which is having a dulplicates data in bot the fact tables. the measure and the columns which are being used from these two tables are causing the issue in loading the matrix and table visual this is what i observed and when i removed one of the measure among the two measures from the visual which has the formuala as below 

# Trans = calculate(SUM(SalesCount[fSalesTX])+0,USERELATIONSHIP(FactSales[SaleCode],SalesCount[SaleCode]),'YTD/QTD/MTD/LQ/LM/LW/Today/Yest/MAT','YTD/QTD/MTD/LQ/LM/LW/Today/Yest/MAT'[LY/PY]="")

# Trans LY = calculate(SUM(SalesCount[fSalesTX])+0,USERELATIONSHIP(FactSales[SaleCode],SalesCount[SaleCode]),'YTD/QTD/MTD/LQ/LM/LW/Today/Yest/MAT','YTD/QTD/MTD/LQ/LM/LW/Today/Yest/MAT'[LY/PY]="LY")

when i remove the one of the above mentioend measure from the matrix visual there was little differnce in loading the data. 

please suggest and need the assistance on the above issue how can i load the data fast and i will share the snip of the report page which has the slicer and visuals in it.

Model is as below for factsales and Salescount

i am selecting the 2021 slicer and QTD or YTD b selecting these two i should retrive data faster.

hoping some one could relpy for the mentioned concern, thanks in advance.

Regards

Anil katta

[ppm1]

The main issue is that you have a M:M relationship between your fact tables. You should re-model to avoid that. Please see this video.

(1) Handling MULTIPLE fact tables in Power BI - YouTube

Pat