Tony Valentine on 20 Mar 2015 03:50:23
I know its a bit strange that we would want to configure the Power BI SSAS connector to point to an HTTP msmdpump, but it allows us to do something we can't do when going directly to the server. However, when I get to the last phase where it creates the connection in Power BI, it returns a strange "The remote server return an error: (404) Not Found....." that I do not get when going directly to the server. Could you validate my results and perhaps fix?
- Comments (28)
RE: Support SSAS connection using HTTP data pump (msmdpump.dll)
I have the same scenario in my organization - Users are not allowed to access SSAS directly because it is in another security zone. We must use http for this communication.
RE: Support SSAS connection using HTTP data pump (msmdpump.dll)
'@Mini Nair
What is your scenario? Can you share more details? Can you access the AS server from Excel or SSMS?
we have a custom authentication flow (IHTTPMODULE), which we manage as a modules over MSMDPUMP.
we fork the request's made to analysis services (AS), enrich the requests with custom data. before AS can process them.
it just does not make sense to have this module anywhere else. MSMDPUMP makes it easy to set up custom pipelines before and after AS handles the request.
RE: Support SSAS connection using HTTP data pump (msmdpump.dll)
Our corporate network security rules insist on a 3 tier architecture and require us to put our SSAS server in a database DMZ and we have to go through a midware layer or web proxy to reach it from applications. We can't connect to it directly. We have data pump configured and it works great from Excel and we can import into Power BI Desktop but live query is what we need for our end users. This is the single barrier preventing us from rolling it out enterprise wide.
RE: Support SSAS connection using HTTP data pump (msmdpump.dll)
Well msmdpump.dll is not supported but it appears Power BI has added the capability to map usernames. If you go to the Data Source Settings and toggle to the Users tab, there is a button called Map User Names which lets you alter the EffectiveUsername string via custom mappings. Thank you MSFT for adding this feature!!
RE: Support SSAS connection using HTTP data pump (msmdpump.dll)
this requirement is really a big need for large ISV's hosting lots of customers. Row level security is simple and the amount of licenses that MSFT can sell would be large. Please consider this feature request. At least let the Enterprise Gateway support it without having to do the UPN handshake which will not work for hosted customers that are not on their domain... this is a basic problem.
RE: Support SSAS connection using HTTP data pump (msmdpump.dll)
Hi,
I have the same requirement, I am developing a SAAS application based on SSAS data and I would like to let external users connect to my cube without the process of creating them / syncing them in my AD. In my case there should be hundreds of users and creating an AD account for each of them in my domain is not a good option.
RE: Support SSAS connection using HTTP data pump (msmdpump.dll)
Hi, I have few customers who wants to buy power bi but with possibility to connect via msmdpump.dll (https)
RE: Support SSAS connection using HTTP data pump (msmdpump.dll)
Hi, you can connect with Power BI desktop, but onl browsing not "Connecting Live" because they somhow forgot to put the auth dialog box in it. So open Pbi desktop and browse it, you can retrieve some info, but it will crash you AS instance, rapidly consuming all you memory if you choose any measure, you might get away with tables and dimensions if they are not too big. Please Power BI team implement this scenario! :)
RE: Support SSAS connection using HTTP data pump (msmdpump.dll)
This still does not work with the release version of Power BI Analysis Services Connector. It fails with the same 404 error. Any update on where this feature is on the priority list?
RE: Support SSAS connection using HTTP data pump (msmdpump.dll)
I asked Power BI uservoice about msmdpump.dll support, and the response was as follows:
"At the moment we don't support connecting via msmdpump. Please go ahead and suggest it in our forum!"
We are using the Telerik Pivot Grid which uses msmdpump.dll, and I also believe infragistics uses it also. Having this support in Power BI is also good for demos and testing SASS scenarios without going through a Federation process.
Excel supports msmdpump.dll. msmdpump.dll can be setup as anonymous for quick testing of a new SSAS service, and have basic authentication added.