Embed power bi load report is very slow

[Ahmad-Masoud]

it is need a lot of time to retrieve the data and show the visuals from the power bi

Thanks 

[v-nmadadi-msft · Accepted solution]

Hi  @Ahmad-Masoud ,
Thanks for reaching out to the Microsoft fabric community forum.

To optimize Power BI report performance, start by reducing data volume by filtering out unnecessary rows and columns. Optimize DAX queries by using efficient functions and avoiding complex measures that slow down calculations. Aggregating data at the source instead of performing complex calculations in Power BI can also improve performance.
 To examine the performance of the report elements, you might use the Performance Analyzer in Power BI Desktop. The Performance Analyzer allows you to see and record logs that measure how each of your report elements performs.
Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Micr...
To improve Power BI Embedded configuration, ensure that you are using a Premium Capacity SKU with sufficient resources, such as the A, EM, or P series, to handle the workload efficiently. Adequate capacity helps enhance performance, reduce loading times, and provide a smoother user experience when embedding reports.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards

[v-nmadadi-msft]

Hi @Ahmad-Masoud ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and regards

[v-nmadadi-msft]

Hi @Ahmad-Masoud,

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 and give a 'Kudos' so other members can easily find it.

Thank you.

[v-nmadadi-msft]

Hi @Ahmad-Masoud ,

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.

Thank you.

[girishthimmaiah · Accepted solution]

- Improve your data model The most important way to do so: Keep data only that really matters: get rid of Unnecessary Columns & Tables. Filter your way to lesser volumes of data: restrict data to relevant periods (last 12 months). Star Schema Design: It's a star schema model that connects fact tables to dimension tables. 2. Improve DAX Performance: Take Out Complex Measures: Simplify your DAX formulas by placing CALCULATE or FILTER in moderation. Pre-Aggregation of Data: Pre-aggregate sums in your data source instead of computing them on-the-fasis. Auto Date/Time Disabled: Stop auto-generating hierarchies of dates/times in Power BI settings. 3. Data Source Performance: Now DirectQuery is faster compared to Import Mode: In Import Mode, data will be loaded into Power BI. Import Mode: It has a better performance than the others, as it will import data into Power BI. DirectQuery: It does live querying of the source, which gives it a slower nature. Make sure these queries use proper indexing to allow the execution of efficient queries. 4. Visual Optimization and Report Level: Limit Visuals per Page Too many visuals slow performance down, so reduce their number. Simpler Visuals: Complicated chart types require much longer rendering time, as in the case where maps are included. Avoid Slicers on Huge Columns: More problematic with high-cardinality columns, like a transaction ID to name but one. 5-embed configuration tips. Use Premium Capacity: Embedding into Power BI as a Premium makes good performance. Cache Reports: Take advantage of caching capabilities available in Power BI to hold temporary reports. Embed Code Optimization: Ensure the embedding code is efficient and doesn't reload the report unnecessarily. 6. Monitor Performance: Performance analyzer tool: Use the Performance Analyzer built into Power BI Desktop to track slow visuals. No ongoing issues should have affected the service for the Power BI.

[v-nmadadi-msft · Accepted solution]

Hi  @Ahmad-Masoud ,
Thanks for reaching out to the Microsoft fabric community forum.

To optimize Power BI report performance, start by reducing data volume by filtering out unnecessary rows and columns. Optimize DAX queries by using efficient functions and avoiding complex measures that slow down calculations. Aggregating data at the source instead of performing complex calculations in Power BI can also improve performance.
 To examine the performance of the report elements, you might use the Performance Analyzer in Power BI Desktop. The Performance Analyzer allows you to see and record logs that measure how each of your report elements performs.
Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Micr...
To improve Power BI Embedded configuration, ensure that you are using a Premium Capacity SKU with sufficient resources, such as the A, EM, or P series, to handle the workload efficiently. Adequate capacity helps enhance performance, reduce loading times, and provide a smoother user experience when embedding reports.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards