Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have my 15+ PBI report built on my own personal desktop but dataset is reside on different server from remote desktop. So, when ever auto refresh happens it will create around 20 or more Microsoft Mashup Evaluation Container on remote desktop server which consume lot of memory (92%) and CPU. After refresh happends still it doesn't releash the Microsoft Mashup Evaluation Container task.
Any workaround on how to release the space consumes by this mashup container?
Any solution would be highly appreciated.
@Tahreem24 this is a big topic and you probably need to dissect the project into parts.
If you are solely using
SQL for transformation (make sure SQL query is optimized - if possible store them in dataflow)
and PQ only for loading (if possible query stored dataflow)
and DAX for analysis, the next step is probably to optimize your DAX measures,calculations,derived tables,calculated columns.
@Tahreem24 my two cents would be to do majority of the transformation server side by utlizing a sql server and insert the sata there from different sources, use pqwry only to load data and use dax for the analysis.
@smpa01 Thanks for your reply. We mostly do transformations at SQL Server end. But Still it's blocking lost of memeory and CPU though.
Any other suggestions that would prevent the mashup engine automatically after refresh done.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |