https://community.fabric.microsoft.com/t5/Report-Server/Power-Bi-running-VERY-slow/m-p/3524916#M31746 <P>First, what is slow? Processing (refresh)? Opening report on portal(loading)? Or Interactive work (queries)?</P><P>Second, 5GB is huge. Standard limit for reports on PBIRS is 1GB. You need to optimize model, or use SSAS model instead PBI model.</P> Thu, 09 Nov 2023 11:18:13 GMT josef78 2023-11-09T11:18:13Z https://community.fabric.microsoft.com/t5/Report-Server/Power-Bi-running-VERY-slow/m-p/3523321#M31730 <P>Hello all,</P><P>&nbsp;</P><P>I am experiencing a very poor performance from Power BI.</P><P>The dataset is around 5 GB which is not huge.</P><P>&nbsp;</P><P>In the model we have a lot of dimension tables that is connected to 2 different fact tables. In total 75 queries</P><P>&nbsp;</P><P>Overall the transformations besides renaming columns are not really a lot.</P><P>&nbsp;</P><P>Do you know what might be happening? Is it the amount of tables loaded?</P><P><img /></P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Wed, 08 Nov 2023 19:11:20 GMT https://community.fabric.microsoft.com/t5/Report-Server/Power-Bi-running-VERY-slow/m-p/3523321#M31730 andicornejo12 2023-11-08T19:11:20Z https://community.fabric.microsoft.com/t5/Report-Server/Power-Bi-running-VERY-slow/m-p/3524916#M31746 <P>First, what is slow? Processing (refresh)? Opening report on portal(loading)? Or Interactive work (queries)?</P><P>Second, 5GB is huge. Standard limit for reports on PBIRS is 1GB. You need to optimize model, or use SSAS model instead PBI model.</P> Thu, 09 Nov 2023 11:18:13 GMT https://community.fabric.microsoft.com/t5/Report-Server/Power-Bi-running-VERY-slow/m-p/3524916#M31746 josef78 2023-11-09T11:18:13Z