Forum Discussion

Fernandostn's avatar
Fernandostn
Frequent Visitor
1 year ago
Solved

Report very slow

Hello, I have a report in Power Bi Report Server that takes a long time to run in import mode and consumes 250GB of memory  I'm researching some forums and I came across some checks that could help,...
"Power BI Report Server "
report slow opening
  • v-menakakota's avatar
    v-menakakota
    1 year ago

    Hi Fernandostn ,

    Thank you for reaching out to us on the Microsoft Fabric Community Forum.


    I think the settings you're looking at belong to a separate Analysis Services (SSAS) instance, not the one used by Power BI Report Server. When you publish a report to Power BI Report Server (in Import mode), it uses a built-in, hidden SSAS instance behind the scenes 

     Because this instance is managed internally by Power BI Report Server, its configuration (like memory limits) can’t be changed through the SSAS properties window you’re viewing.

    Please follow the below steps to improve performance:

    • Optimize your data model: remove unused columns, avoid high-cardinality fields.

    • Use Performance Analyzer in Power BI Desktop to see which visuals are slow.

    • Monitor server resources during report execution (especially memory usage).

    • Consider aggregations or splitting large reports into smaller ones if possible.

      If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

      Thank you.

Fernandostn's avatar
Fernandostn
Frequent Visitor
1 year ago

I appreciate the feedback

And are there any of these parameters that if I change them could improve the execute time?

 

 

v-menakakota's avatar
v-menakakota
Community Support
1 year ago

Hi Fernandostn ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.


I think the settings you're looking at belong to a separate Analysis Services (SSAS) instance, not the one used by Power BI Report Server. When you publish a report to Power BI Report Server (in Import mode), it uses a built-in, hidden SSAS instance behind the scenes 

 Because this instance is managed internally by Power BI Report Server, its configuration (like memory limits) can’t be changed through the SSAS properties window you’re viewing.

Please follow the below steps to improve performance:

  • Optimize your data model: remove unused columns, avoid high-cardinality fields.

  • Use Performance Analyzer in Power BI Desktop to see which visuals are slow.

  • Monitor server resources during report execution (especially memory usage).

  • Consider aggregations or splitting large reports into smaller ones if possible.

    If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

    Thank you.