PowerBI is a great data modelling tool but it has several key limitations compared to SQL Analysis Services.
What if you want to know how big the model is? Or if you want to re-use DAX calculations somewhere else? Maybe you're fed up of your users having all the control and you want to turn it into an SSAS tabular model?
What if you want to pull out a list of all the dimensional attributes so you can provide a data dictionary, or even to put the data into Azure Data Catalog?
Well you can do all this, by hook or crook, and Simon will show you how.
YOU MAY ALSO LIKE:
Hacking PowerBI - Tips & Tricks for Working with PBI Models
Simon Whitely is Principal BI Consultant with Adatis. Simon has been working with the Microsoft BI Stack for a decade, starting off building traditional warehouses with SSIS and SSAS but bringing in alternative technologies where needed. Simon is a strong advocate of the use of modern development practices in the SQL World.