Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tannera
Advocate II
Advocate II

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

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. 

7 REPLIES 7
v-shex-msft
Community Support
Community Support

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
If this post helps, please consider accept as solution to help other members find it more quickly.

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.  

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

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
If this post helps, please consider accept as solution to help other members find it more quickly.

Thanks for your response. 

 

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

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

+1 . Did run in the same issue today. No problem to connect via https to SSAS via Excel,Tableau,XLCubed...BUT NOT with Power BI Desktop? Can't belive that this still is not possible in 2020. Seems to be more a PBI Desktop UI Bug then a real technical limitation (as other client tools work without issue)?!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.