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.

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

Hi  Fernandostn  ,

Thanks for reaching out to the Microsoft fabric community forum. 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily. 

Best Regards, 
Menaka.
Community Support Team  

 

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

    Hi  Fernandostn ,

    May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster. 


    Best Regards, 
    Menaka.
    Community Support Team 

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

      Hi Fernandostn ,

      I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

      Best Regards, 
      Menaka.
      Community Support Team