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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Power BI - Migration of SSAS database to Live Connection

Hello Team,

 

We are using SSAS for storing aggregated data for Power BI Reporting. We would like to use Live Connection (Analysis Service). How to migrate our SSAS DB to Live connection.

Thanks,

PBI_v2

1 ACCEPTED SOLUTION

Can we create Analysis Service database in Power BI cloud

We call that a Power BI Dataset - it presents as a SSAS Tabular cube.  You can use all the SSAS commands for queries and partition management against these Power BI datasets.

View solution in original post

5 REPLIES 5
lbendlin
Super User
Super User

No need to migrate anything.  Connect from Power BI to your SSAS source. That connection by default will be a live connection.

Anonymous
Not applicable

Thanks for your response.

Our SSAS database is "On premises" SSAS Server. I heard that Live connection meaning SSAS database can be loaded in Power BI cloud and we can do Power BI reporting from Power BI Cloud Analysis instance. Could you please charify.

 

Thanks,

PBI V2

Still the same process. Since your SSAS is on-premise you need an enterprise gateway too. Make sure it has a very fast network connection.

Anonymous
Not applicable

Thank you for your response. One last question- Can we create Analysis Service database in Power BI cloud and can do similar reporting like on premises SSAS to Power BI Reporting
Current Situation -  SQL Server Analysis Service to Power BI Reporting

Expected - Analysis Service (in Power BI Cloud) to Power BI Reporting

 

Thanks,

PBI V2

Can we create Analysis Service database in Power BI cloud

We call that a Power BI Dataset - it presents as a SSAS Tabular cube.  You can use all the SSAS commands for queries and partition management against these Power BI datasets.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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