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
LuisQuedas
Advocate I
Advocate I

Power BI Desktop and the HTTPs Data pump - Power BI Product Team Official position required!!!

Hi Community, 

 

I need your help to understand what's the current and official position of Microsoft Power BI Program team regarding the SQL Server Analysis Services HTTP data pump, (HTTPs endpoint). 

 

Last year I've written some posts about how to use Power BI with the HTTPs endpoint, but so far there are some doubts and questions about it because there isn't an official position of  PBI product team about it.

I've proven that  it works, check out the following posts: 

http://www.luisquedas.com/2017/10/how-to-connect-power-bi-desktop-to-olap_9.html

http://www.luisquedas.com/2017/10/how-to-publish-power-bi-report-that.html

 

But from other community's posts I got

" I'm surprised you managed to make the live connection to a msdmpump.dll work because Microsoft responded to me, saying it is not supported in live connection. "

http://community.powerbi.com/t5/Desktop/PowerBI-Desktop-using-HTTP-endpoint-to-connect-an-OLAP-Cube-...

 

" As confirmed with Product Team, this kind of connection type (HTTP Access to AS server) may still work in some condition. But actually, it's already not supported today"

http://community.powerbi.com/t5/Desktop/PBI-Desktop-Sept-2017-update-returning-error-when-trying-to/...

 

We have several customers using PBI Desktop connected to SQL Server Analyses Services through the HTTPs Data pump, they made huge investments in OLAP development during the last 10/15 years and now they are using PBI to create their reports but they are very nervous about this situation... Is it possible to have an official position from Power BI Product Team about this way to connect the SQL Server Analysis Services cube? or how can I get that information ASAP?

 

Many Thanks, Luis

 

2 REPLIES 2
rsfurlan90
Frequent Visitor

Hello @LuisQuedas,

 

I am stuck in the same situation, and appreciate all your efforts to help Power BI users to work around that Live Connection restriction when using HTTP Data Pump (msmdpump.dll). In my case, however, I have another web service layer that is actually exposed to our customers, so that we can validate the user credentials in the context of our solution, then calls the Data Pump and wraps the response to be sent back to the client. With this, we can remove from the list databases that a specific user hasn't granted access to, thus isolating data as we have shared infrastructure to host many databases for many customers. This additional layer has been working like a charm, as Tableau and Excel have already proved that. We really need that Power BI Desktop becomes able to configure a Live Connection with Analysis Services, but also provide a way get connected via Basic Authentication, which is only available if we Import Data, which is not an option for us for many reasons.

 

Have you opened a ticket for that, as suggested by @v-chuncz-msft?

 

I would really like to follow that, if you don't mind, because I haven't see any progress on this matter.

 

Thanks

v-chuncz-msft
Community Support
Community Support

@LuisQuedas,

 

You may directly create a support ticket.

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

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.