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...
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
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

      • tannera's avatar
        tannera
        Advocate II
        9 years ago

        Thanks Sylvain for your answer. 

         

        Did you ever encounter the impossibility to live connect to the pump using that method? From day one, we're not able to connect this way. In Excel or Tableau we have no problems. 

         

         

        Microsoft even say the live connection is not supported in this recent thread I made: https://community.powerbi.com/t5/Desktop/Any-timeline-on-when-a-live-connection-to-a-msmdpump-dll-SSAS/m-p/231183

         

        So I'm actually surprised you managed to live connect to your msmdpump.dll 

         

        What steps did you take for it to authentify you correctly? 

         

        Thanks