cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
simonboucher57 Frequent Visitor
Frequent Visitor

Connecting to a Multidimensional model on Azure

We need to move an existing, On-Premises, Analysis Services Multidimensional Model, a cuble, to the Cloud on Azure?
1. is this possible? What connector or service should be used?
2. how are we suppose to do that? We can't find any documentation from Microsoft!

Ultimate goal is to use Power BI in Self-Service Mode to connect to our Multidimensional Model in the Cloud and publish Power BI Dashboards to SharePoint onlinne!

Thanks!
Simon

Business Analytics Strategist
2 ACCEPTED SOLUTIONS

Accepted Solutions
FrankK Frequent Visitor
Frequent Visitor

Re: Connecting to a Multidimensional model on Azure

Analysis Service multi dimensional can only run on Azure Virtual Machines as IaaS. They do not have a SaaS that supports Analysis Services. I suppose from there you would use the data gateway to connect to the cube on the VM for your Power BI dashboards...

Super User
Super User

Re: Connecting to a Multidimensional model on Azure

1. is this possible? What connector or service should be used?

 Yes as Frankk mentions above. Your only option currently is using the personal gateway for refresh and connecting to your cube via Power BI Desktop. This is a link to the personal gateway - you need this to refresh the data on the site, not to connect to your cube.
2. how are we suppose to do that? We can't find any documentation from Microsoft!

Ultimate goal is to use Power BI in Self-Service Mode to connect to our Multidimensional Model in the Cloud and publish Power BI Dashboards to SharePoint onlinne!

Sign up for power bi, download the Power BI Desktop, connect to your model. The Iaas is treated like an on-premise data source which is why you need the Personal Gateway.

For a whole slew of information, try looking on the support site here

Also, Power BI in Sharepoint is not how the new Power BI works. It's more it's own product now with different features to share etc. There has recently been an update and you can utilize API's to embed Power BI elements on your site (found here), which would most likely look something like this implementation that you can use for Excel and PowerPoint. Understand that the "new" Power BI doesn't work or behave like the "old" Power BI that is being phased out in December.

Near SE WI? Join our PUG Milwaukee Brew City PUG
4 REPLIES 4
FrankK Frequent Visitor
Frequent Visitor

Re: Connecting to a Multidimensional model on Azure

Analysis Service multi dimensional can only run on Azure Virtual Machines as IaaS. They do not have a SaaS that supports Analysis Services. I suppose from there you would use the data gateway to connect to the cube on the VM for your Power BI dashboards...

simonboucher57 Frequent Visitor
Frequent Visitor

Re: Connecting to a Multidimensional model on Azure

Thanks FrankK!

Have you seen any documentation on this topic?

Simon

Business Analytics Strategist
Super User
Super User

Re: Connecting to a Multidimensional model on Azure

1. is this possible? What connector or service should be used?

 Yes as Frankk mentions above. Your only option currently is using the personal gateway for refresh and connecting to your cube via Power BI Desktop. This is a link to the personal gateway - you need this to refresh the data on the site, not to connect to your cube.
2. how are we suppose to do that? We can't find any documentation from Microsoft!

Ultimate goal is to use Power BI in Self-Service Mode to connect to our Multidimensional Model in the Cloud and publish Power BI Dashboards to SharePoint onlinne!

Sign up for power bi, download the Power BI Desktop, connect to your model. The Iaas is treated like an on-premise data source which is why you need the Personal Gateway.

For a whole slew of information, try looking on the support site here

Also, Power BI in Sharepoint is not how the new Power BI works. It's more it's own product now with different features to share etc. There has recently been an update and you can utilize API's to embed Power BI elements on your site (found here), which would most likely look something like this implementation that you can use for Excel and PowerPoint. Understand that the "new" Power BI doesn't work or behave like the "old" Power BI that is being phased out in December.

Near SE WI? Join our PUG Milwaukee Brew City PUG
simonboucher57 Frequent Visitor
Frequent Visitor

Re: Connecting to a Multidimensional model on Azure

Thanks Eno!

Simon

Business Analytics Strategist

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 280 members 3,049 guests
Please welcome our newest community members: