Report very slow

[Fernandostn]

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,

This screen below is the Analysis Service configuration, if I make the changes here will it affect the execution of my reports?

Or does this Analysis Service have nothing to do with the Analysis Service that appears in the Task Manager?

Tks

[v-menakakota]

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]

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]

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  

[Fernandostn]

I appreciate the feedback

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

 

[v-menakakota · Accepted solution]

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.

[rohit1991]

Hi @Fernandostn ,

It sounds like you're encountering a common issue when connecting to MySQL in Power BI via the cloud, where the service expects an encrypted connection by default. Even though you've set the data source's encryption setting to "not encrypted," Power BI's cloud service (particularly when using the on-premises data gateway or direct cloud connectors) still attempts to establish a secure connection unless the MySQL server explicitly allows unencrypted traffic. This error typically arises when either the MySQL instance is not configured correctly to accept such connections or when Power BI cannot successfully negotiate the connection protocol due to mismatched SSL settings.

To resolve this, ensure that your MySQL server has SSL explicitly disabled if you intend to use unencrypted connections, or better yet, enable SSL and provide the required certificates for a secure and supported configuration. Keep in mind that Microsoft is gradually enforcing stricter security standards, so using encrypted connections is strongly recommended and more future-proof.

Passionate about leveraging data analytics to drive strategic decision-making and foster business growth.

Connect with me on LinkedIn: Rohit Kumar.

[R1k91]

Power BI Report Server creates a "phantom" SSAS Tabular instance to host semantic models that you publish via PBIX. You can connect to it as "localhost:5132".

You can even install your own SSAS Tabular instance on the same server, in this case you should see 2 SSAS processes in the task manager.