Forum Discussion
Migrate Power BI SSAS reports
We have around 50 Power BI reports created using on premises SSAS database with Live connection, SSAS is going to retire soon and will be replaced by Snowflake, we are currently using 3 SSAS cubes, each SSAS cube is used by 10-15 Power BI reports. We can use Premium license as well
6 Replies
What's your question? There is the ability to Migrate SSAS to Power BI Premium and there is a wizard built into PowerBI.com service.
Here's a blog from Microsoft on how to do it
https://learn.microsoft.com/en-us/analysis-services/tabular-models/import-from-analysis-services-ssas-tabular?view=asallproducts-allversionsOops, sorry about that. Here is the right link
HI hvnter
are there any limitations of this approach?
Good morning, I haven't had any limitations other than you need to be configured with ADLS Gen 2. The only other thing to consider is if you were using Tabular models and refreshes as a way to get around the limited refresh schedule of Import Models hosted in premium, you'll need to do some extra work using either Azure Data Factory or Power Automate to get your custom refresh schedule back. I've done both so happy to answer those questions if/when you get there
Hi hvnter ,
once SSAS model is migrated on to power bi dataset then if we point existing Power BI reports on to Power BI dataset then would my existing reports work seamlessly without throwing any error?
