Forum Discussion
What is Microsoft mashup evaluation container? How it impacts the data refresh?
Hi Anonymous
Please see my answers below.
1. What is Microsoft mashup evaluation container?
GQ - This is the Power Query Editor Engine that completes all the steps that were done in the Power Query Editor. It also compresses the data using the xVelocity Engine.
2. Will it only run when import model is used in Power BI?
GQ - Yes it will only run to import and convert all the data into the data model.
3. Is this used while sourcing the data from source only or for loading the data to Power BI xvelocity engine further?
GQ - It is also used when sourcing data, because the Power Query Editor is responsible for importing data, making changes to data and converting it into the data model.
4. I am working with 100 Mn data and applied sorting for better compression. Will Microsoft mashup evaluation container be used for this purpose also?
GQ - Yes it will still be used, it should hopefully be quicker, because it will not have to sort the data.
We have requirement to have last 36 months of data to be present in the report. I tried implementing incremental refresh also but as of date, one field in the fact table should be of date time format for incremental to work. In our fact table Datekey is coming in "20180301" format. I converted this field to Date time field using Power Query but it results engine not to run native queries to the data source. This further results in bringing all data from fact table and then converting it to DateKey and apply filters.
I am thinking of creating a view in the datasource with Date Time format field now.
One question: Is there any timeout limit for on premises data gateway? It seems all refreshes which takes less than 2 hours are completing fine but beyond 2hours is timing out. Although we are using P1 capacity but still this is happening.
Thanks
Super UserI have not had data take that long to refresh. At one customer I did have 10 million rows that took 20mins to complete.