Forum Discussion

S-Driancourt's avatar
S-Driancourt
Frequent Visitor
9 years ago
Solved

Using HTTP data pump (msmdpump.dll) leads to (can't display visual) errors

Hi Everyone,
In order to avoid opening port with fixed IPs we are also trying to connect Power BI Desktop in live connection to SSAS 2016 Multidim through http://..../msmdpump.dll

It globally works, but we have frequent errors (Can't display visual) with the message: "The http server returned the following error: Service unavaible". Please note that we only use standard wisuals.
-->This is strange, because this seems to be randomed. When we click on Refresh we can get the visual to work.
By changing back the source connection to SERVER:PORT we do not get the error.

We have noticed that this happens in Reports having a lot of visuals. So maybe it's just a matter of simultaneous connections.... But we just can not figure out where it comes from 

 

We have the exact same behaviour after publishing the report on Power Bi Services.


Has anyone else experienced this?

Dashboards
Gateways
  • S-Driancourt's avatar
    S-Driancourt
    9 years ago

    Thank you very much Qiuyun Yu for your feedback.

    We just found the solution to our issue and you were right, the issue was coming  from the IIS Server, or mor precisely from the configuration of the msmdpump.

    We read the following article:

    http://amolpandey.com/2016/08/26/ssas-msmdpump-dll-failing-occasionally-under-high-user-loads/

     

    And we added the following 3 lines in the msmdpump.ini file

    <MinThreadPoolSize>0</MinThreadPoolSize>
    <MaxThreadPoolSize>0</MaxThreadPoolSize>
    <MaxThreadsPerClient>20</MaxThreadsPerClient>
     
    Now we do not have the issue anymore, in Power BI Desktop or in Power BI Services
    Best regards,
    Sylvain

7 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi S-Driancourt,

     

    Based on my test with the http://<IP address>/OLAP/msmdpump.dll in latest desktop version 2.44.4675.521 and service, all visuals can display fine in the report. Please try to use the same desktop version as ours.

     

    From the error message, the issue should be related to the SSAS server or IIS server. Please check logs generated on that two servers side to see if any issue occurs at the tome that error throws out. Verify both SSAS and IIS service are running. 

     

    Best Regards,
    Qiuyun Yu

  • S-Driancourt's avatar
    S-Driancourt
    Frequent Visitor
    9 years ago

    Thank you very much Qiuyun Yu for your feedback.

    We just found the solution to our issue and you were right, the issue was coming  from the IIS Server, or mor precisely from the configuration of the msmdpump.

    We read the following article:

    http://amolpandey.com/2016/08/26/ssas-msmdpump-dll-failing-occasionally-under-high-user-loads/

     

    And we added the following 3 lines in the msmdpump.ini file

    <MinThreadPoolSize>0</MinThreadPoolSize>
    <MaxThreadPoolSize>0</MaxThreadPoolSize>
    <MaxThreadsPerClient>20</MaxThreadsPerClient>
     
    Now we do not have the issue anymore, in Power BI Desktop or in Power BI Services
    Best regards,
    Sylvain
    • tannera's avatar
      tannera
      Advocate II
      9 years ago

      Hi S-Driancourt, 

       

      How did you get a live connection in Power BI desktop to your msmdpump.dll? Did you use a connection string?  

       

      Kind regards

      • S-Driancourt's avatar
        S-Driancourt
        Frequent Visitor
        9 years ago

        Hi !

        When you create your data connection, you choose  SQL Analysis Services database.
        Then instead of the server name you put the URL : http;//myserver/OLAP/msmdpump.dll.

         

        Exactly the same way you connect through Excel.

        Sylvain

        PS: sorry for my late answer, I was away theses days