Awesome vid! Starting at 15:08, here is the first demo scenario in a nutshell. Created SSAS Data Model in Visual Studio Deployed Data Model to SQL Server Management Studio -On Prem Connected Power BI to on prem Data Model and created quick report. Also deployed Data Model to Azure Analysis Services, just as easy on cloud as On Prem. Reconnected Power BI to Azure Cloud Data Model to Power BI
Great video! Unfortunately, MS has removed the web tool to import and create models in the portal. Now you have to use Visual Studio. I did find a way to export the power bi model and import it into Azure Analysis Services but it's a huge pain.
this is what I found. www.desertislesql.com/wordpress1/?p=2176 anythting easier? I am tempted to just start from scratch in AAS on VS instead of importing from PBI.
Hello Yinch, unfortunately no. AAS only supports tabular models. If you want a Multidimensional model on Azure, you will need to have an SSAS Instance installed on an Azure VM.
Hi...I am trying to connect Azure SQL DW in Direct Query mode with SSDT and get this error - Failed to save modifications to the server. Datasource has authentication kind OAuth2. This is not supported in DirectQuery 1400 mode. I read in the MS docs that Direct Query mode is not supported with OAuth credentials. Need help.
Great Video mate all setup perfectly but when we update the data on origin sql server it gets updated on visual studio but when deployed it does not show on analysis services any suggestion regarding the updates not replicating. Thanks again
![Azure Synapse Analytics: Introduction [Introduction to Azure Synapse Analytics Series - Ep. 1]](http://i.ytimg.com/vi/1UHCiletocg/mqdefault.jpg)
3 years later and this video is still valuable. Thank you!
Awesome vid! Starting at 15:08, here is the first demo scenario in a nutshell.
Created SSAS Data Model in Visual Studio
Deployed Data Model to SQL Server Management Studio -On Prem
Connected Power BI to on prem Data Model and created quick report.
Also deployed Data Model to Azure Analysis Services, just as easy on cloud as On Prem.
Reconnected Power BI to Azure Cloud Data Model to Power BI
Nice job Brad! I'll be sure to share this
Great video! Unfortunately, MS has removed the web tool to import and create models in the portal. Now you have to use Visual Studio. I did find a way to export the power bi model and import it into Azure Analysis Services but it's a huge pain.
this is what I found. www.desertislesql.com/wordpress1/?p=2176
anythting easier? I am tempted to just start from scratch in AAS on VS instead of importing from PBI.
PBI now has an XMLA Endpoint where you can connect and get the dataset definition which will let you use it to create a model on AAS.
Hello ,i want to know how we can check how much time a model is taking for complete process/refresh (full/Partition)
Great video. Thanks a lot for clear explaination on how to get started.
Thanks for nice explanation.can you please provide some video on azur analysis services 😊😊
Brad is the Real Deal, very clearly explained! Is the Multi-dimensional model going to be supported in AAS?
Hello Yinch, unfortunately no.
AAS only supports tabular models. If you want a Multidimensional model on Azure, you will need to have an SSAS Instance installed on an Azure VM.
Hi...I am trying to connect Azure SQL DW in Direct Query mode with SSDT and get this error - Failed to save modifications to the server. Datasource has authentication kind OAuth2. This is not supported in DirectQuery 1400 mode.
I read in the MS docs that Direct Query mode is not supported with OAuth credentials.
Need help.
Great Video mate all setup perfectly but when we update the data on origin sql server it gets updated on visual studio but when deployed it does not show on analysis services any suggestion regarding the updates not replicating. Thanks again
Excellent ! Thans
We are glad to hear that you liked the video.
Awesome video!
Awesome video🎉🎉