Date
Attendees
- Unknown User (pavan.narayanan)
- Jeffrey A Jensen
- Lisa Michelle Applegate
- Steven Premeau
- John A. St. Peter
- Microsoft: Dustin & Senthil
Goals
- See process for moving a PBI Data Model to SSAS
- Is this a feasible option if we are in Report Server? (Data models in PBI can be shared in the Cloud)
Discussion items
Same DB engine in SSAS Tabular as Power BI; because of this, we can do many similar things.
Sometimes compatibility issues (version issues). If Report Server, PBI, Cloud, and SSAS versions should match. If versions don't match, may need to start from scratch with creation.
When you open a PBI model in PBI, you are running SSAS underneath
DAXStudio (free tool) to connect to SSAS or PBI model. Use server info at the bottom of the DAXStudio screen, then in Management Studio, connect to server name from prior step.
Use create script from here (relationships, tables, calculations, all are encoded here). Then connect to SSAS instance. New XMLA query, create script. Need to change compatibility level to dial PBI back to SSAS (currently 1200)
There are some things that are not compatible (this was an incredibly simple example):
Date/Time Hierarchies not supported in SSAS, for example....
Good resource on PBI to SSAS model conversion: DesertIsleSQL: Upgrading a Data Model from PBI to SSAS