Forum Discussion

mmouton's avatar
mmouton
Frequent Visitor
10 months ago

Poor performance with Power BI API for paginated reports compared to SSRS

Hello, We are moving a series of paginated reports from SSRS (on-premise) to Power BI. The .rdl files are hosted on a workspace licensed by a Fabric capacity F4. I have migrated the reports to Powe...
Need Help
mmouton's avatar
mmouton
Frequent Visitor
10 months ago

Hi,

The previous response is very comprehensive. I'm comparing performance for one report, but I'm moving around 80 reports from SSRS to Power BI.

I don't see how optimizing queries or reducing data volume can have a significant impact because the reports are working, the database can easily handle requests and loadings.

We've already worked on report optimization and it seems very painful to re-iterate through all reports...

Fabric capacity isn't throttled.

Again, thank you for taking the time to answer my question, but I'm disappointed that the options seem very heavy (moving data to Azure SQL, redesigning reports) in regard to the problem (moving from on-premise to Power BI).

  • v-aatheeque's avatar
    v-aatheeque
    Community Support
    10 months ago

    Hi mmouton 

    Thanks for getting back and sharing those details. It looks like you’ve already gone through the suggestions shared by rohit1991 around gateway setup, capacity checks, and report performance tweaks.

    Since the issue is still happening even after those steps, have you had a chance to raise a support ticket with Microsoft yet? That would let the backend team review your Fabric capacity logs in detail and see if there’s any service-related latency or delay causing this.
    Microsoft Fabric Support and Status | Microsoft Fabric