Power BI desktop and url connection to SSAS cubes using the http msmdpump.dll. How to?

Power BI desktop and url connection to SSAS  cubes using the http msmdpump.dll. How to?

We have a url setup that gives a user access to our SSAS Cubes in Excel. That works fine no problem. (http://olap.mycubes.com)

But now we have a new user that needs to do the same thing in Power BI.

When I enter the URL in the prompt for server it gives me an "unsupported data format" error.

How do go about doing this for Power BI?
Paul MaurielloSoftware Programmer Developer Analyst EngineerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
It seems like a gig. Let me know, if you need any help. I can do it for you, but it will cost you.
Paul MaurielloSoftware Programmer Developer Analyst EngineerAuthor Commented:
I appreciate the response but I'm just looking to do it myself. Shouldn't be that earth-shattering for me to do. I was looking for Premium Experts Exchange advice like I always get ...not completely outsource the task in its entirety to another developer.

http://biinsight.com/connect-live-power-bi-to-ssas-multidimensional/

The above link provides insight and coupled with your response I can conclude it is indeed possible which answers half my question. I'm just wondering what I'm missing and why I'm getting this immediate timeout error when I try to do it.

I'm using SQL 2014 Standard but also have access to SQL Server 2016 Enterprise if need be. Is that a factor?

Do I need to setup a power BI gateway to do it? I'm missing something.
Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
Yes. I can understand .

For your reference Live connection will not work with standard edition for 2014 or previous version. Only Business intelligence version will support Analysis service live.

SQL server 2016 standard will support live connection.

On Premises Help

And Power Bi gateway is necessary only if you want to publish report to powerbi services and have live connection to your data source

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Paul MaurielloSoftware Programmer Developer Analyst EngineerAuthor Commented:
Thank you that last bit of information was all i needed.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSAS

From novice to tech pro — start learning today.