Azure Analysis Services Tutorial | Scale Power BI reports into hundreds of GBs

[@afignu77]

Congrats Adam, it's one of the best videos I've seen this year about Azure cloud, analysis services, visual studio everything integrated with pbi, well done!!

[@alt-enter237]

Really well done. I am going to suggest that Power BI Guy in A Cube start looking at your channel when they do round ups .This was a really great overview.

[@AdamMarczakYT]

You are too nice! This is soo nice to hear! Thanks! :)

[@yasielmesa1603]

Adam you are amazing! I'm having troubles explaining analysis services to some of my co-workers but you just made it easy!

[@AdamMarczakYT]

Fantastic :) glad to hear!

[@hiteshjoshi3148]

HI yasiel is tutorial enough if one knows ssas and trying to migrate to cloud.

[@maadala]

Amazing way to building AAS ans connecting from Power BI. Thanks a lot for your time in making this video, helping tons of people across the globe

[@AdamMarczakYT]

You are most welcome :)

[@stompao]

Thank you very much Adam for your help! We have created an AAS, update the information from the Data Factory. Your video has served as a guide and inspiration for our project. Love from Spain and Merry Christmas!!! ⛄⛄⛄

[@AdamMarczakYT]

Awesome :) glad to be of help! merry x-mas to you too!

[@sumaiyaks6280]

Thank you for this Adam! Very useful for beginners who know nothing about Azure too

[@vamsikrishna254]

One word I would like to say "Fabulous" I got clear picture now.. Thanks tons.

[@AdamMarczakYT]

Great to hear! Thanks :D

[@johng5295]

Adam: thanks in a million! Very well explained. This is the nth time that I am watching this again. Great content. Awesome. I couldn't find this explanation--simply put anywhere else. “Great teachers are hard to find”. Grade: A++ 💥

[@siddhi166]

Thank you Adam. This was very helpful. Waiting for more content on Azure Analysis Services

[@AdamMarczakYT]

More to come! Thanks!

[@sanakhatoon4536]

Thank you Adam! It clears all my doubts related to AAS, You have covered end to end topics from creating AAS to deploying model to connecting it to the Power BI. Thanks in tons! 😊

[@dibakarroy3853]

Very informative, especially for me who is novice here, though I have good exposure to Power BI. Good to see how I can leverage Azure. Thanks

[@AdamMarczakYT]

Thank you, glad you enjoyed it. I did think a lot of Power BI users might be interested in this and this is why I made so many comparisons :).

[@hiteshjoshi3148]

HI Dibakar sir iam learning power bi and want to learn Azure analysis services though i havent learn ssas though i know DAx and data modelling is this tutorial enough to learn AAS.

[@hiteshjoshi3148]

HI Dibakar sir iam learning power bi and want to learn Azure analysis services though i havent learn ssas though i know DAx and data modelling is this tutorial enough to learn AAS.

[@arun06530]

as always..your video tutorials make complex topics simple.. Thank you

[@derekwilson6446]

Thanks Adam, this is a great video and literally explains A to Z on Azure Analysis Services and more. Really appreciate it.

[@arunlouie]

Very nice explanation close to real time usage. Thank you!!

[@AdamMarczakYT]

Thank you :)

[@AArora81]

As aware. This is a great introduction. Amazing content to get started. Thanks Adam for sharing!

[@AdamMarczakYT]

My pleasure!

[@harithik1]

Fantastic video. This deserves more views. Very upto the point. Clear and concise. What more I can say.. :)

[@AdamMarczakYT]

Much appreciated!

[@mercydabbs3330]

Thank you!!!!!!!!!!!!!!!!!!!! I wish the video can be longer. This is very helpful! But you didn't talk about how to use the dataverse (common data model) with azure

[@AdamMarczakYT]

My pleasure. Dataverse is not Azure, it's Power Platform and it didn't exist at the time of making this video.

[@mercydabbs3330]

@@AdamMarczakYT How can I attend a formal training?

[@billmanassas7746]

I am surprised that azure analysis services is not so popular among Bi professionals! I find it extremely handy

[@AdamMarczakYT]

Cheers Bill! I agree, probably because of low entry cost of power bi which makes AAS very costly investment for many organizations. It also has some drawbacks and a lot of competition in this space.

[@terryliu3635]

@@AdamMarczakYT Hello Adam, i found your reply to this interesting. Could you please help elaborate a little bit more about the key drawbacks and other competitors in this space? Thanks in advance.

[@lukaszrutkowski]

Czesc Adam, dzieki za ten filmik, bardzo mi sie przydal. Zaczynam przygode z Azure od niedawna wiec subskrybuje :)

[@AdamMarczakYT]

Dzięki Łukasz. Takie rzeczy miło słyszeć. Kiedyś planuje więcej w tematyce AAS i BI reporting ale narazie ciasna agenda i jeszcze pare waznych serwisow do pokrycia. :) Pozdrawiam!

[@mehulbhatia3241]

Really simple and easy to understand

[@poojanarayan8363]

This was so helpful! Right what I needed. Thank you.

[@AdamMarczakYT]

Glad it was helpful!

[@asimfakhi]

This is really a great tutorial.. I really liked the way you make the slides and animations to explain the concepts.

[@AdamMarczakYT]

Thanks a lot!

[@asimfakhi]

I'm really excited to get a reply from you... Can I get in contact with you I'm also interested in learning Azure and teaching it to everyone so we can have really great champs in Cloud computing community.

[@sagar_patro]

Thanks Adam for the detailed explaination, I am amazed.

[@AdamMarczakYT]

Superb! Thank you mate :)

[@genaugenaugenau]

Really great overview Adam, well done

[@AdamMarczakYT]

Thank you!

[@tjvillanueva396]

Thanks for this wonderful video Adam

[@AdamMarczakYT]

My pleasure!

[@data-bass]

great video, thanks!

[@AdamMarczakYT]

Thanks Lance, Glad you liked it!

[@shampytakkar2614]

Nicely explained. Could you also do a demo on TMSL and create models, relationships, perspectives in Analysis services

[@AdamMarczakYT]

Noted, thanks for watching :)

[@VipinKumar-mk7km]

Great video Adam, quick and relevant , saves time and explains well also. Thank you , i liked it (y)

[@thomasjordan454]

Fantastic video - thank you!

[@AdamMarczakYT]

Glad it was helpful! Welcome aboard Thomas :)

[@drummerboi4eva]

Thanks so much , great explaination of Azure Analysis services, really inspiring !

[@AdamMarczakYT]

Great to hear!

[@janisaksson5966]

Great stuff. Thank you!

[@AdamMarczakYT]

It's my pleasure Jan!

[@albeeliu7658]

great tutorial, I learn lots of things in this video.Thanks !!

[@TerranIMBA123]

It was a nice video but I have some questions (coming from AWS background): 1. Isnt the main purpose of Analysis Services and Tabular modeling to provide columnar compression? I would expect Azure Analysis services to be deployed on Azure SQL DWH to further compress the data since big data loads are, well, big 2. Can Analysis Service be deployed on Postgres or MySQL? Or is it proprietory to Microsoft SQL db engine? 4. Can Analysis Services also read directly from Parquet delta tables (or Spark dataframes)? Or does the data format always need to be CSV 3. Can other BI tools like Qlik Sense or Tableau also connect to Azure Analysis Services? Would appreciate the response! Thanks

[@AdamMarczakYT]

Great questions. 1. AAS is a standalone service. It's not deployed on anything. While it's true that it is a part of SQL server family it's a separate columnar store in memory database. 2. Not sure I understand here. It's PaaS so you don't worry what is it hosted on behind the scenes. If you are talking about on premises AAS, then yes, only SQL Server is the option as it is a product from SQL server family. 3. Not yet. Check the list of available data sources here: docs.microsoft.com/en-us/azure/analysis-services/analysis-services-datasource?WT.mc_id=AZ-MVP-5003556 4. No idea. Not an expert on those, check their docs/websites :)

[@ajitkumar4684]

Adam...can you please do a video on how to incrementally load Tabular Models and the best approach to create dynamic partitions.

[@AdamMarczakYT]

Great suggestion! I'll add it to the list of potential topics.

[@ajitkumar4684]

@@AdamMarczakYT Hi Adam. Need another help. What are the advantages/disadvantages of using AAS Direct query over Power BI direct query to the same Data Source. Actually I am trying to understand whats the benefit as my data source is Azure SQL DW and I have to implement Direct Query with AAS.

[@vireshkolagimath4264]

simple and straight to business. Good one, thanks

[@AdamMarczakYT]

Cheers!

[@philc8544]

Brilliant video. I would be interested to learn more about using visual studio to perform more transformations of the data instead of power query if it is possible?

[@AdamMarczakYT]

You can use either DAX or Power Query. If you need more complex transformations then try other services like data factory/databricks/etc.

[@dhonymadruga]

Hi. Thanks for it. Amazing content.

[@yogeshbansal7184]

Thank You So much Adam I was exactly looking for similar video to understand role of SSAS in Power BI. I am still unable to find a good playlist created only for SSAS + Power BI. I hope you will help us. Thank You once again. May God Bless You. Do Good, Feel Good.

[@harveywang1395]

Great demo, thanks 1000 brother

[@MasterCamus]

After transforming the data in power query in VS and importing the data, how can I access power query again in VS?

[@AdamMarczakYT]

Right click on the table, select table properties and then design.

[@lovelace0586]

very clear👍

[@azimkamal1532]

Hi Adam. I have a question. When we use AAS, should we use import mode or direct query/live when connecting to power bi? What are the pros and cons?

[@tonyocnos6691]

Great video Adam!!! Suuuuper helpful! Dzienki!

[@mateuszmozgawa5416]

Perfect video. Do you maybe know how to connect with AAS from linux using oauth token?

[@techproductowner]

Great video once again! 1.Can we connect any other bi tool apart from power bi to azure analysis service or it has to be power BI 2.What language is the language used to build the data warehouse in Azure -SQL server ? Or other ? 3.What language is used for reporting-at report level for gui/analytics qn- thing? eg DAX/SQL /other ?

[@AdamMarczakYT]

1. Unfortunately I don't know other reporting tools that do. 2. SQL 3. DAX

[@techproductowner]

Thank you for your reply

[@jonamprasad1]

Hi Adam, I am looking for setting up CI CD pipelines for Azure Analysis Services in Azure Devops using Microsoft plugin. Can you please provide a guideline if any. Since I can't find any Microsoft documentation for AAS CI CD pipelines

[@gastondemundo9822]

when I create a model in azure SSAS the name of the database appear with my name and the name of the model and with many numbers random after. Are there anyway to change the database name to the original name that I have my project ?

[@sonsangsom]

Thanks Adam, may I ask can we use AAS this as a data warehouse?

[@anilbabu5500]

Wow this is brilliant, thank you

[@AdamMarczakYT]

You're very welcome!

[@vivekanandareddychundi5230]

One quick question though: If source data size is little bigger, the livr connection querying would be very very bad. So the other option is Import method which only accepts certain amount of data. In such cases do we need SSAS? Please assist

[@yagnam123]

Any information on AAS cubes?

[@data-bass]

is Azure Analysis Services going to be deprecated in favour of semantic modelling in Power BI Data Services?

[@AdamMarczakYT]

Normally I'd say it's possible looking at the Power BI Premium roadmap, but as it stands Today I'd say we're not there yet, there weren't even any rumors on it either. So probably not, lots of active development happens in AAS too. There are a few differences between them too.

[@Vladerrama21]

great video Adam, thx! Being new to these concepts still confused on when to use Analysis Service vs Analytics Service vs Data Factory. Any practical hints?

[@prabhatdass6184]

hello Adam, I am a subscriber and want to know how we can check how much time a model is taking for complete process/refresh (full/Partition), Complete execution time. specially when i am running it manually.

[@AutomationBIAI]

hi Adam , I do not see the PQ screen. it is the old relational db screen. anything wrong here ? thanks

[@AdamMarczakYT]

Hey, you probably selected the old compatibility level of the project when you created it. You need to have compatibility level of 1400 or 1500. You can change it by changing project properties.

[@arulmouzhiezhilarasan8518]

Great Adam once again!

[@AdamMarczakYT]

Cheers!

[@piotrjan2927]

I got an error when trying to run BISM Normalizer "Tabular Model Comparison": Method not Found: 'Microsoft.AnalysisServices.Tabular.Model Microsoft.AnalysisServices.Tabular.Model.Database.get_Model()' It turns out, it conflicts with SSIS extension to Visual Studio. So you have to disable it and restart VS to make BISM extension work.

[@AdamMarczakYT]

Thanks Peter for sharing, I didn't had this issue but I don't really develop in SSIS anymore. Hope it helps someone here! :)

[@piotrjan2927]

@@AdamMarczakYT You are ahead of the game. I am trying to catch up:)

[@Creosignum]

Sorry by my ignorance but whats the difference between a model and a view/materialized view in the database?

[@AdamMarczakYT]

AAS models are like in memory database designed for high frequency queries at very very high speed. Database view is just a query definition. Materialized view is query definition with cached result on the disk. Of'course this is simplification but in general this is how it is. Good question.

[@sandeepgunda7650]

Hi Adam,I have gone through the video I have a question for you, still Microsoft did not develop a process to pull data from Cubes from Azure Analysis Services yet?

[@maranp6618]

please post a video on azure synapse...

[@AdamMarczakYT]

In June my friend!

[@maranp6618]

Thanks a lot adam!!really like your videos....@@AdamMarczakYT

[@hiteshjoshi3148]

Sir is it enough if one knows ssas and trying cloud migration.And thanks for the tutuorial.

[@AdamMarczakYT]

Thank you, it really depends on what do you want to do, But generally be ready a learn always! :)

[@amarnadhgunakala2901]

Very cool video, Any thoughts on part II?? Because i have already watched ADF all videos and now this one, basically I'm Microsoft BI guy wanting to get in to Azure platform , suggest me what and all needs to be covered on Azure? Thanks Adam anyways.

[@AdamMarczakYT]

Cool! thanks! For BI, I guess move step by step by learning core services (SQL/SQL DW (synapse), Databricks, ADF, logic apps, etc.) for data and/or maybe focus on reporting side like AAS/SQL and Power BI platform. But you need to choose that path yourself.

[@venkatbesthavemula2292]

Great demo Adam. Thanks a ton. But is there a way to configure automtic scale out/in, instead we chose from portal.

[@imedbenhamouda6816]

Hello Adam, Very good demo. Can you share Github links for this demo. Thanks

[@AdamMarczakYT]

Thanks!! Didn't notice I missed the link in the description. updated! Here is the model and sample data: github.com/MarczakIO/azure4everyone-samples/tree/master/azure-analysiservices-introduction

[@liamboyd4676]

Does tableau has this built in?

[@massimocheah3027]

This video is very informative and I manage to resolve my problem with your video. However I am encountering another problem - do you have any idea how we can auto refresh Azure Analysis Services ?

[@AdamMarczakYT]

In general I use this asynchronous API do it from Azure Logic Apps docs.microsoft.com/en-us/azure/analysis-services/analysis-services-async-refresh?WT.mc_id=AZ-MVP-5003556 which I described on my blog marczak.io/posts/2019/06/logic-apps-refresh-analysis-services/ and here marczak.io/posts/2019/06/logic-app-vs-data-factory-for-aas-refresh/ and in few days I plan to release a video on this subject as well so if you like feel free to check it out later. I will use new and improved refresh pattern there :)

[@massimocheah3027]

Adam Marczak - Azure for Everyone thanks for ur reply. It is awesome.

[@vishwanathr3507]

HI Adam My Power BI reports are connected to SSAS tabular model Power BI reports response is very slow SSAS tabular model is on-premises Power BI reports published in Power BI service These reports are using live connect to SSAS Any suggestion/thought, would be helpful.... Thank you Vishwanath

[@AdamMarczakYT]

Hey, unfortunately there are too many variables. It might be networking issue or just slow AS model. You would need to perform full analysis using DAX studio/query profiler to understand this. You could potentially move your AS to AAS to ensure it's close to your power bi service so there would be no networking issues.

[@vishwanathr3507]

@@AdamMarczakYT Thanks Adam for your reply I have too many measures in Power BI report level, I should create them in AS. Since we have licensed server in On-premises we deployed it, we do not have AAS. I do perform analysis using DAX studio and check the performance pitfalls. I have copied your suggestions to move to AAS Best Regards- Vish

[@srikanthnama]

Hi Adam, I am getting error "On-Premise Gateway is required to access the data source. Please install a unified gateway for the server xxxxxxxx or disable AlwaysUseGateway setting if it's enabled." when I am trying to deploy the model to AAS. I don't remember seeing you creating a gateway in this demo. Do you know what am I missing here ? Are we supposed to install a gateway ?

[@AdamMarczakYT]

It depends on the firewall settings and the location of the source that you are connecting to. If you have sources behind the firewall or in on-premises environment then you need a data gateway.

[@ajitkumar4684]

Hi Adam...With Power BI Premium capacity (Dataset connectivity with XMLA endpoint) I believe Azure Analysis Services will no longer be required to host the Tabular Models. If I develop a Tabular Model (using Visual Studio) and then just deploy it to a workspace in the Premium capacity, don't you think that AAS is no longer required in this case. Please suggest. Thank you

[@AdamMarczakYT]

I'd say it's not so simple just yet. Maybe in future Power BI Premium will replace AAS but for now I say it's still not the case. Especially because of the limitations. For example, P1 which costs incredible amount of 4,999$ USD has only 25 GB of memory where AAS that costs 2,900 is already 50GB. But of'course those are different products because PBI Premium also grants volume read licenses and other cool features like embedding while AAS is simple backend engine only. In PBI Premium you can only have up to 10GB dataset after which you need to implement incremental loads, in AAS there is no such limitation. I could list many more items like this but I hope you get the idea. As of now, they are similar but still different products so they fit different scenarios.

[@ajitkumar4684]

@@AdamMarczakYT kzbin.info/www/bejne/fZvRpmSvi6iVr5Y This Video blog from MS says that we can have large datasets in Premium (400 GB, Parity with Azure Analysis Services).

[@AdamMarczakYT]

I didn't say you can't. I said "... after which you need to implement incremental loads " which is exactly what is described in the video. But again it says up to memory capacity of Power BI premium so P3 is only 100GB and you need to leave about 20-50% to be able to cache queries. Also P3 is 20,000$ per month. With 24,000 you get AAS S9 capacity which is 400 GB memory. I'm not saying PBI premium is bad, just at this moment it's not a replacement of AAS for very very big models. But it has some nice features so often we combine the two.

[@discovery-dx3ry]

Thank you, Adam.

[@AdamMarczakYT]

My pleasure!

[@terryliu3635]

Good intro and demo, thanks much! QQ, at 21:32, were you using live or import?

[@AdamMarczakYT]

It was live, connectivity is shown at 21:23 mark. Thanks!

[@shubhambusiness6202]

lovely

[@sandeeppai25]

Is it possible to use tableau as reporting tool with analysis services?

[@AdamMarczakYT]

That's a tableau question not an Azure one :) I think it can but check their docs.

[@rishabhmaini8285]

Hey Adam, Great Video! Do you know how to setup automatic refreshes on the AAS model? I have a Power BI report that uses AAS model, but how do I setup the refresh on AAS model to get the latest data?

[@shampytakkar2614]

You will have to use automation account and write runbook code to refresh your AAS model. That way, you can automate AAS refresh

[@hiteshjoshi3148]

Sir can one directly learn azure analysis service without learning SSAS.

[@AdamMarczakYT]

You can learn Azure without prior knowledge, but it's easier if you do. But not requried!

[@alansilva3826]

Amazing video, the only question left is what type of licencing do we need to work with visual studio + analysis service interface(i know it is a extension in the newest versions). I'm currently working with Visual Studio 2017 + AS and is hellish slow and clumsy. And a last question, is it possible to schedule processing the model directly from azure, if yes do you have an video or reference link?

[@AdamMarczakYT]

As far as I remember Visual Studio Community 2019 can be used for free for commercial use for Analysis Services projects. Or you can use SSDT 2017 standalone installer. As to processing remotely check my logic app refreshing demo on my blog marczak.io/posts/2019/06/logic-apps-refresh-analysis-services/

[@terryliu3635]

Hello Adam, I just watched this video for a second time. Thanks again. Do you have a video on the differences between the tabular model and the multidimensional model. I'm not so sure if we should choose Azure SQL Database (with Azure DW or not) + AAS or choose Sql Server on virtual machine with SSAS OLAP capabilities. I personally prefer tabular model because of my experience in SAP HANA, however, I need solid facts or points to help the team make the architecture decision, tabular model, why or why not? Thanks.

[@AdamMarczakYT]

Thanks for checking it out. Well, most of the differences are explained here: docs.microsoft.com/en-us/analysis-services/comparing-tabular-and-multidimensional-solutions-ssas?view=asallproducts-allversions but also keep in mind having platform to manage (SSAS) versus managed service (AAS) is additional cost and support. Also AAS will most likely get more and more new features. Key thing that I noticed is that multidimensional models don't have M expressions so you can't connect to as many sources as in tabular natively. AAS also has REST api which can be used for automation of refreshes and few other features. Seems like it's Microsoft's direction.

[@terryliu3635]

@@AdamMarczakYT thanks Adam for your reply. I feel too this ROLAP model within AAS is the direction of Microsoft in this area. I will check out the doc you shared above. Another quick question if you do not mind, do you know if the model within AAS can take variables or input parameters? e.g., in the model in HANA, modelers can defined variables or input parameters, users then can pass Current Year Month e.g., 202003 to the query to calculate YTD measures or apply filters using variables if for instance, they only need to extract records of certain company codes or years to Power BI. With AAS, do we have to load all the records from the in-memory model using live or acquire based connections?

[@AdamMarczakYT]

Note that live connection is not loading any records to power bi. It's always generating query on the fly, if you put page or report level filter to 202003 then all queries will be executed for this month only and will only return results for that subset of data.

[@ajitkumar4684]

Hi @Adam Marczak - Azure for Everyone...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.

[@AdamMarczakYT]

I don't remember trying to use AAD authentication for AAS refreshes from DW. But if the documentation states this is not supported then how can I help? :)

[@ajitkumar4684]

@@AdamMarczakYT Thanks for replying Adam. Actually, there are no details mentioned on the portal and so I approached you. docs.microsoft.com/en-us/azure/analysis-services/analysis-services-datasource#oauth-credentials Also, I cannot use the Standard SQL Server Authentication becoz there is RLS implemented in the source, Azure SQL DW and the requirement is to Impersonate User credentials in the Direct Query mode. I am stuck :(

[@AdamMarczakYT]

Yeah, unfortunately pass-through authentication is not supported at the moment :( not sure if there is any workaround for that,

[@amitverma1802]

Is there a way so that I import existing powerbi model into visual studio tabular rather than creating from scratch and then deploy that to analysis services and use that analysis services into powerbi as you did..do you think this will help to handle the huge volume and performance.... as well as setting up devops pipelines for migrating changes..?just thinking on these few points..please share your opinion

[@AdamMarczakYT]

you can do that very easily using Tabular Editor, open power bi model > change address to AAS > deploy, or extract the model file and add this to visual studio, both will work just fine

[@AdamMarczakYT]

yes, you can use devops to deploy AAS models, my largest project in AAS handled around 2 TB of data but that was a stretch already, I'd aim for 500GB maximum (before compression)

[@ghay3]

Thanks Adam. Would I be able to pull data from a SQL MI - transform - deploy to Azure Analysis Services? I get a connection error when attempting to deploy even though I can download tables and transform them in my Visual Studio. Not sure what I am missing here. I get no error however when following your tutorial and using a blob storage

[@AdamMarczakYT]

Probably firewall on SQL MI is blocking the connection from AAS.

[@ghay3]

@@AdamMarczakYT Appreciate your reply, many thanks. It was resolved by installing an on-prem Gateway. Apparently this is required when using SQL MI

[@sreekumarmenonk7678]

Great video..:) Why did youtube take so long to bring to me :? i have a question.. They say that Power BI Pro has a capacity of 4GB and Premium up to 10GB. Now, as you said, with Azure Analysis Services we get to scale up to 400GB.. So are all this capacities mentioned available in memory? like, after compression?

[@AdamMarczakYT]

Thanks! Hopefully next time youtube will recommend me faster! haha. As to your question, I'm not Power BI guru but I think your numbers are off, where did you get them? Last time I checked power bi premium has also maximum memory capacity of 400GB, it is also much more expensive than AAS because it provides additional features. As to second part of your question this is IN-MEMORY capacity, so a compressed model + cache for your user queries. So recommendation is to keep your model below 50% of maximum memory capacity.

[@sid0000009]

Thanks for the quick win videos. Do you think there is way AAS modelling could support Power BI reporting for data feeds which are more real time in nature. As I know all the Models needs to be refreshed either by Automation Services, REST API or Logic Apps. Data basically would sit inside in AAS Memory but source data changes would not be reflected unless refreshed?

[@AdamMarczakYT]

Hmm tough question. Only way I'd think about be direct query connection to database, if you import then you need to refresh. But AAS allows partial refreshes so you can refresh quite often and quite rapidly so no issue here. Usually when source data changes ETL calls AAS to refresh related tables in the model.

[@sid0000009]

@@AdamMarczakYT thanks Adam

[@narra_rakesh_2021]

Any documents for this tutorial

[@AdamMarczakYT]

Github code sample and links to relevant documentation references are available in the video description.

[@sid0000009]

Thanks for your great videos. So in summary we have AAS or Power BI to create our models for reporting. Do you have any recommendations in which case we should use AAS and when we use Power BI considering AAS is quite expensive for big data sets. Thank you

[@AdamMarczakYT]

This is spot on question, but the answer is longer so let me try to explain this in few sentences. In general I think it comes down to whenever Power BI can hold your dataset in memory. Power BI pro has up to 1GB memory and as soon as you start building reports which consume this you will get out of memory exceptions on your visualizations and experience major slowdown. Considering 5-100 (by the docs) and in reality 10-15 times compression rate of AAS tabular models we're talking here models containing 10-15GB of data. So not enough for big reporting solutions. At that point it's between AAS and Power BI premium, and that is another story since they have different features too. But cheapest available Power BI premium from the marketplace is $5,000 and cheapest AAS is $600 so for those medium sized reports it fits nicely. But still there are many more consideration between premium vs aas but in short regular power bi vs AAS is just size of the models.

[@sid0000009]

@@AdamMarczakYT So major parameter would be volume of data & performance. There is a limit of 100 TB per Premium capacity in Power BI. Thank you as always for your inputs.

[@sid0000009]

@@AdamMarczakYT : If we consider sharing the data models , do you think AAS has an upper hand. With large dataset support in Power BI premium size is competitive with AAS so think it could be a major deciding factor .. Any thoughts? Do you have any article to refer between Power BI premium and Azure AAS .. thankyou

[@martinointero]

Hi Adam can you advise if we can pause AAS from ADF?

[@AdamMarczakYT]

You can use Web Activity with Managed Identity to make a call to Azure Management REST API and call this action docs.microsoft.com/en-us/rest/api/analysisservices/servers/suspend

[@Bharath_PBI]

Hi, I'm a first timer here, I work with ssas on Prem and planning to switch to aas, can you or do you have any video covering all the aspects of incremental refresh in aas? Like having partitions in ssas and processing them, and aad, roles and rls etc .. thanks again 👍

[@AdamMarczakYT]

Thanks! Appreciated! I don’t have yet any videos for SSAS to AAS migration paths or advanced AAS topics unfortunately. I plan to put out some in the future though :). Currently working on improving my video making flow so that I can release more videos faster. Thanks for watching!

[@Bharath_PBI]

@@AdamMarczakYT Great, love to look forward for those content. Keep up the excellent work 👍

[@SA-bw1je]

All well and good, nice tutorial...however. Trying to follow along, my version of Visual Studio doesn't look like this. It doesn't have the Power BI power query bit to import from Azure blob, like Power BI...I've kinda avoided MS products as much as possible over the years, much prefer MySQL/PostGreSQL/Oracle to T-SQL and Sql Server...Visual studio installed at around 8.7GB, and I was trying to be conservative. Then, no matter which version, I still didn't see it like in this video. VS Community 2017 or 2019, or Enterprise. Wow. Life is so simple with out all the MS bloat...MS, sometimes, less is more - more is just bloat!!!

[@AdamMarczakYT]

Thanks. In the video I mentioned you need to make sure to have model in version at least 1400+. At 1200 you will see exactly what you describe. I’m not going to comment much on bloatware comment but in general bloatware for me is things that run in the background that slow down your PC. VS doesn’t do that. 9GB in times where we have 250/500GB or 1TB+ drives is nothing :).

[@SA-bw1je]

@@AdamMarczakYT Thanks Adam!!! Top guy! You really helped me, all the info I need in one place rather than having to search here or there. May you be rewarded with goodness!!!

[@GrabowskiMaciej]

dzieki

[@AdamMarczakYT]

Przyjemnosc po mojej stronie!

[@jujubalismel]

wow amazing video! I am wondering how I can refresh the database in Analysis Service automatic. For example I have my data in SQL then I put it in Analysis Service, but my data is not refreshing automatically when I change my database in SQL. Do you know how I can fix my problem? Thanks!

[@AdamMarczakYT]

Thank you Juli :) If you want you can use logic apps to refresh models in AAS. I wrote about this on my blog marczak.io/posts/2019/06/logic-apps-refresh-analysis-services/ and here from data factory marczak.io/posts/2019/06/logic-app-vs-data-factory-for-aas-refresh/

[@sid0000009]

@@AdamMarczakYT /Juli ..We have used Azure Automation Power Shell Script to refresh and orchestrate it via Azure ADF Web Call. It works well as we need to refresh only after we complete our daily loads. . So as the ADF pipeline finishes the AAS Data Model also gets refreshed with latest data. ..Just an alternative approach

[@jayakrishna9153]

Hi Adam,if you don't mind could you please share me the slides that ur showing for each topics...it would be very helpfull if you could share..Thanks in advance

[@AdamMarczakYT]

Hey Jaya unfortunately I don't share slides at this time. Hope you understand. Best regards!

[@jayakrishna9153]

@@AdamMarczakYT Thanks np.. i understood

[@fredericdesmet1689]

My imported CSV looks a little differnt 😅

[@AdamMarczakYT]

Hmm, not sure why, did you use supplied sample?

[@jayakrishna9153]

excellent

[@AdamMarczakYT]

Thanks Jaya.