Reply
Regular Visitor
Posts: 50
Registered: ‎07-27-2017

Any timeline on when a live connection to a msmdpump.dll (SSAS) will be supported?

[ Edited ]

The import mode works with a msmdpump.dll (SSAS) connection but not the live connection due to a bug with the authentification from Power BI. When will this be fixed? Live connection to the pump works with Excel and Tableau. 

Community Support Team
Posts: 7,505
Registered: ‎08-14-2016

Re: Any timeline on when a live connection to a msmdpump.dll (SSAS) will be supported?

[ Edited ]

HI @tannera,


I think it is feature than a bug.

Based on research, it seems like a route mapping pool application who used to dynamic switch SSAS datasource.
Actually, current live mode in power bi not support dynamic changed datasource, it is complex to change current datasoruce to another one.

 

In addition, if you share more detail information about this issue, it will be help for troubleshooting.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Regular Visitor
Posts: 50
Registered: ‎07-27-2017

Re: Any timeline on when a live connection to a msmdpump.dll (SSAS) will be supported?

It cannot be a feature if Excel and Tableau support a live connection through the pump. 

 

This is what happens:

 

Live connection to the SSAS pump does not work. 

pump1.png

 

 

But when selecting 'Import' instead of 'Connect live', the same link works and we get an authentification menu. 

 

When using our login details in the 'Basic' menu, the connection works. In the 'Windows' login it does not work. 

 

pump2.png

 

Can you confirm if this will ever be fixed, because our (and our clients') adoption of Power BI pro/premium depends on msmdpump.dll live connection support.  

Regular Visitor
Posts: 50
Registered: ‎07-27-2017

Re: Any timeline on when a live connection to a msmdpump.dll (SSAS) will be supported?

Is there a method to live connect to the SSAS with a connection string in PBI Desktop?

 

I just tried with Power BI Report Server. The data source connection asks for a connection string and authentification, so I was able to connect successfuly to the SSAS to the pump. 

 

pump3.png

 

 

 

 

pump4.png

Highlighted
Community Support Team
Posts: 7,505
Registered: ‎08-14-2016

Re: Any timeline on when a live connection to a msmdpump.dll (SSAS) will be supported?

Hi @tannera,

 

Based on test, power bi not support live connect to a dynamic SSAS datasource which provided by 'msmdpump.dll'.

 

Actually, it only support to connect to static data source, every time you change the connection string or data, power bi need to rebuild the report and reload the relationships.


For import mode, power bi will import records from current datasource. If you change the stored config file, it may remove cache and reload from new datasource.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Regular Visitor
Posts: 50
Registered: ‎07-27-2017

Re: Any timeline on when a live connection to a msmdpump.dll (SSAS) will be supported?

Thanks for your response. 

 

Any plans to offer an OOTB feature for us to specify a complete SSAS connection string? 

Frequent Visitor
Posts: 8
Registered: ‎03-03-2017

Re: Any timeline on when a live connection to a msmdpump.dll (SSAS) will be supported?

I am also looking forward for the answer. Tableau and Excel have this capability, this is a must have.