Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

What is Microsoft mashup evaluation container? How it impacts the data refresh?

Hi All,   I am currently troubleshooting one data refresh issue in Power BI where we are sourcing data from Oracle Public Cloud (Import Model). When my gateway is running during refresh, I could se...
Need Help
  • GilbertQ's avatar
    GilbertQ
    8 years ago

    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.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
8 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi GilbertQ,

     

    Can you explain the fourth point in detail?

    In my case one instance of Microsoft mashup evaluation container keeps running and this results into timeout.

     

    Thanks

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      8 years ago
      Hi there,

      For the fourth point, I think what is happening is because you are doing the sort operation over 100 million rows, it is taking a very long time to return the data. And this is taking longer than the timeout specified in the connection.

      What you could do is to change the Timeout on the SQL Connection to be longer?
      Also potentially put a clustered index on the SQL table, which should return the data immediately because when the index is created it will sort the table.
      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi GilbertQ,

         

        Thanks for the reply. Actually in my case Power BI Desktop is not timing out. It runs successfully everytime but in Power BI Services it times out when I am refreshing a huge dataset (93Mn records). We are using P1 Premium capacity and still it times out sometime even after 2 hours.

         

        Thanks