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-enter2374 жыл бұрын
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.
@AdamMarczakYT4 жыл бұрын
You are too nice! This is soo nice to hear! Thanks! :)
@yasielmesa16033 жыл бұрын
Adam you are amazing! I'm having troubles explaining analysis services to some of my co-workers but you just made it easy!
@AdamMarczakYT3 жыл бұрын
Fantastic :) glad to hear!
@hiteshjoshi31483 жыл бұрын
HI yasiel is tutorial enough if one knows ssas and trying to migrate to cloud.
@maadala4 жыл бұрын
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
@AdamMarczakYT4 жыл бұрын
You are most welcome :)
@stompao3 жыл бұрын
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!!! ⛄⛄⛄
@AdamMarczakYT3 жыл бұрын
Awesome :) glad to be of help! merry x-mas to you too!
@sumaiyaks62802 жыл бұрын
Thank you for this Adam! Very useful for beginners who know nothing about Azure too
@vamsikrishna2543 жыл бұрын
One word I would like to say "Fabulous" I got clear picture now.. Thanks tons.
@AdamMarczakYT3 жыл бұрын
Great to hear! Thanks :D
@johng52952 жыл бұрын
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++ 💥
@siddhi1663 жыл бұрын
Thank you Adam. This was very helpful. Waiting for more content on Azure Analysis Services
@AdamMarczakYT3 жыл бұрын
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! 😊
@dibakarroy38534 жыл бұрын
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
@AdamMarczakYT4 жыл бұрын
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 :).
@hiteshjoshi31483 жыл бұрын
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.
@hiteshjoshi31483 жыл бұрын
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.
@arun065302 жыл бұрын
as always..your video tutorials make complex topics simple.. Thank you
@derekwilson644611 ай бұрын
Thanks Adam, this is a great video and literally explains A to Z on Azure Analysis Services and more. Really appreciate it.
@arunlouie3 жыл бұрын
Very nice explanation close to real time usage. Thank you!!
@AdamMarczakYT3 жыл бұрын
Thank you :)
@AArora813 жыл бұрын
As aware. This is a great introduction. Amazing content to get started. Thanks Adam for sharing!
@AdamMarczakYT3 жыл бұрын
My pleasure!
@harithik14 жыл бұрын
Fantastic video. This deserves more views. Very upto the point. Clear and concise. What more I can say.. :)
@AdamMarczakYT4 жыл бұрын
Much appreciated!
@mercydabbs33303 жыл бұрын
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
@AdamMarczakYT3 жыл бұрын
My pleasure. Dataverse is not Azure, it's Power Platform and it didn't exist at the time of making this video.
@mercydabbs33303 жыл бұрын
@@AdamMarczakYT How can I attend a formal training?
@billmanassas77464 жыл бұрын
I am surprised that azure analysis services is not so popular among Bi professionals! I find it extremely handy
@AdamMarczakYT4 жыл бұрын
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.
@terryliu36354 жыл бұрын
@@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.
@lukaszrutkowski4 жыл бұрын
Czesc Adam, dzieki za ten filmik, bardzo mi sie przydal. Zaczynam przygode z Azure od niedawna wiec subskrybuje :)
@AdamMarczakYT4 жыл бұрын
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!
@mehulbhatia32412 жыл бұрын
Really simple and easy to understand
@poojanarayan83634 жыл бұрын
This was so helpful! Right what I needed. Thank you.
@AdamMarczakYT4 жыл бұрын
Glad it was helpful!
@asimfakhi4 жыл бұрын
This is really a great tutorial.. I really liked the way you make the slides and animations to explain the concepts.
@AdamMarczakYT4 жыл бұрын
Thanks a lot!
@asimfakhi4 жыл бұрын
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_patro4 жыл бұрын
Thanks Adam for the detailed explaination, I am amazed.
@AdamMarczakYT4 жыл бұрын
Superb! Thank you mate :)
@genaugenaugenau4 жыл бұрын
Really great overview Adam, well done
@AdamMarczakYT4 жыл бұрын
Thank you!
@tjvillanueva3963 жыл бұрын
Thanks for this wonderful video Adam
@AdamMarczakYT3 жыл бұрын
My pleasure!
@data-bass3 жыл бұрын
great video, thanks!
@AdamMarczakYT3 жыл бұрын
Thanks Lance, Glad you liked it!
@shampytakkar26143 жыл бұрын
Nicely explained. Could you also do a demo on TMSL and create models, relationships, perspectives in Analysis services
@AdamMarczakYT3 жыл бұрын
Noted, thanks for watching :)
@VipinKumar-mk7km2 жыл бұрын
Great video Adam, quick and relevant , saves time and explains well also. Thank you , i liked it (y)
@thomasjordan4543 жыл бұрын
Fantastic video - thank you!
@AdamMarczakYT3 жыл бұрын
Glad it was helpful! Welcome aboard Thomas :)
@drummerboi4eva3 жыл бұрын
Thanks so much , great explaination of Azure Analysis services, really inspiring !
@AdamMarczakYT3 жыл бұрын
Great to hear!
@janisaksson59663 жыл бұрын
Great stuff. Thank you!
@AdamMarczakYT3 жыл бұрын
It's my pleasure Jan!
@albeeliu76583 жыл бұрын
great tutorial, I learn lots of things in this video.Thanks !!
@TerranIMBA1233 жыл бұрын
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
@AdamMarczakYT3 жыл бұрын
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 :)
@ajitkumar46844 жыл бұрын
Adam...can you please do a video on how to incrementally load Tabular Models and the best approach to create dynamic partitions.
@AdamMarczakYT4 жыл бұрын
Great suggestion! I'll add it to the list of potential topics.
@ajitkumar46844 жыл бұрын
@@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.
@vireshkolagimath42644 жыл бұрын
simple and straight to business. Good one, thanks
@AdamMarczakYT4 жыл бұрын
Cheers!
@philc85443 жыл бұрын
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?
@AdamMarczakYT3 жыл бұрын
You can use either DAX or Power Query. If you need more complex transformations then try other services like data factory/databricks/etc.
@dhonymadruga2 жыл бұрын
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.
@harveywang13952 жыл бұрын
Great demo, thanks 1000 brother
@MasterCamus3 жыл бұрын
After transforming the data in power query in VS and importing the data, how can I access power query again in VS?
@AdamMarczakYT3 жыл бұрын
Right click on the table, select table properties and then design.
@lovelace05862 жыл бұрын
very clear👍
@azimkamal15329 ай бұрын
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?
@tonyocnos66912 жыл бұрын
Great video Adam!!! Suuuuper helpful! Dzienki!
@mateuszmozgawa5416 Жыл бұрын
Perfect video. Do you maybe know how to connect with AAS from linux using oauth token?
@techproductowner3 жыл бұрын
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 ?
@AdamMarczakYT3 жыл бұрын
1. Unfortunately I don't know other reporting tools that do. 2. SQL 3. DAX
@techproductowner3 жыл бұрын
Thank you for your reply
@jonamprasad12 жыл бұрын
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
@gastondemundo98222 жыл бұрын
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 ?
@sonsangsom2 жыл бұрын
Thanks Adam, may I ask can we use AAS this as a data warehouse?
@anilbabu55004 жыл бұрын
Wow this is brilliant, thank you
@AdamMarczakYT4 жыл бұрын
You're very welcome!
@vivekanandareddychundi52302 жыл бұрын
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-bass3 жыл бұрын
is Azure Analysis Services going to be deprecated in favour of semantic modelling in Power BI Data Services?
@AdamMarczakYT3 жыл бұрын
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.
@Vladerrama212 жыл бұрын
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.
@AutomationBIAI4 жыл бұрын
hi Adam , I do not see the PQ screen. it is the old relational db screen. anything wrong here ? thanks
@AdamMarczakYT4 жыл бұрын
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.
@arulmouzhiezhilarasan85184 жыл бұрын
Great Adam once again!
@AdamMarczakYT4 жыл бұрын
Cheers!
@piotrjan29273 жыл бұрын
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.
@AdamMarczakYT3 жыл бұрын
Thanks Peter for sharing, I didn't had this issue but I don't really develop in SSIS anymore. Hope it helps someone here! :)
@piotrjan29273 жыл бұрын
@@AdamMarczakYT You are ahead of the game. I am trying to catch up:)
@Creosignum4 жыл бұрын
Sorry by my ignorance but whats the difference between a model and a view/materialized view in the database?
@AdamMarczakYT4 жыл бұрын
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.
@sandeepgunda76502 жыл бұрын
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?
@maranp66184 жыл бұрын
please post a video on azure synapse...
@AdamMarczakYT4 жыл бұрын
In June my friend!
@maranp66184 жыл бұрын
Thanks a lot adam!!really like your videos....@@AdamMarczakYT
@hiteshjoshi31483 жыл бұрын
Sir is it enough if one knows ssas and trying cloud migration.And thanks for the tutuorial.
@AdamMarczakYT3 жыл бұрын
Thank you, it really depends on what do you want to do, But generally be ready a learn always! :)
@amarnadhgunakala29014 жыл бұрын
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.
@AdamMarczakYT4 жыл бұрын
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.
@imedbenhamouda68164 жыл бұрын
Hello Adam, Very good demo. Can you share Github links for this demo. Thanks
@AdamMarczakYT4 жыл бұрын
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
@liamboyd46762 жыл бұрын
Does tableau has this built in?
@massimocheah30273 жыл бұрын
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 ?
@AdamMarczakYT3 жыл бұрын
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 :)
@massimocheah30273 жыл бұрын
Adam Marczak - Azure for Everyone thanks for ur reply. It is awesome.
@vishwanathr35074 жыл бұрын
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
@AdamMarczakYT4 жыл бұрын
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.
@vishwanathr35074 жыл бұрын
@@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
@srikanthnama3 жыл бұрын
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 ?
@AdamMarczakYT3 жыл бұрын
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.
@ajitkumar46844 жыл бұрын
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
@AdamMarczakYT4 жыл бұрын
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.
@ajitkumar46844 жыл бұрын
@@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).
@AdamMarczakYT4 жыл бұрын
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-dx3ry4 жыл бұрын
Thank you, Adam.
@AdamMarczakYT4 жыл бұрын
My pleasure!
@terryliu36354 жыл бұрын
Good intro and demo, thanks much! QQ, at 21:32, were you using live or import?
@AdamMarczakYT4 жыл бұрын
It was live, connectivity is shown at 21:23 mark. Thanks!
@shubhambusiness62022 жыл бұрын
lovely
@sandeeppai253 жыл бұрын
Is it possible to use tableau as reporting tool with analysis services?
@AdamMarczakYT3 жыл бұрын
That's a tableau question not an Azure one :) I think it can but check their docs.
@rishabhmaini82852 жыл бұрын
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?
@shampytakkar26142 жыл бұрын
You will have to use automation account and write runbook code to refresh your AAS model. That way, you can automate AAS refresh
@hiteshjoshi31483 жыл бұрын
Sir can one directly learn azure analysis service without learning SSAS.
@AdamMarczakYT3 жыл бұрын
You can learn Azure without prior knowledge, but it's easier if you do. But not requried!
@alansilva38264 жыл бұрын
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?
@AdamMarczakYT4 жыл бұрын
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/
@terryliu36354 жыл бұрын
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.
@AdamMarczakYT4 жыл бұрын
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.
@terryliu36354 жыл бұрын
@@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?
@AdamMarczakYT4 жыл бұрын
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.
@ajitkumar46844 жыл бұрын
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.
@AdamMarczakYT4 жыл бұрын
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? :)
@ajitkumar46844 жыл бұрын
@@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 :(
@AdamMarczakYT4 жыл бұрын
Yeah, unfortunately pass-through authentication is not supported at the moment :( not sure if there is any workaround for that,
@amitverma18023 жыл бұрын
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
@AdamMarczakYT3 жыл бұрын
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
@AdamMarczakYT3 жыл бұрын
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)
@ghay33 жыл бұрын
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
@AdamMarczakYT3 жыл бұрын
Probably firewall on SQL MI is blocking the connection from AAS.
@ghay33 жыл бұрын
@@AdamMarczakYT Appreciate your reply, many thanks. It was resolved by installing an on-prem Gateway. Apparently this is required when using SQL MI
@sreekumarmenonk76784 жыл бұрын
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?
@AdamMarczakYT4 жыл бұрын
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.
@sid00000094 жыл бұрын
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?
@AdamMarczakYT4 жыл бұрын
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.
@sid00000094 жыл бұрын
@@AdamMarczakYT thanks Adam
@narra_rakesh_20214 жыл бұрын
Any documents for this tutorial
@AdamMarczakYT4 жыл бұрын
Github code sample and links to relevant documentation references are available in the video description.
@sid00000094 жыл бұрын
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
@AdamMarczakYT4 жыл бұрын
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.
@sid00000094 жыл бұрын
@@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.
@sid00000092 жыл бұрын
@@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
@martinointero4 жыл бұрын
Hi Adam can you advise if we can pause AAS from ADF?
@AdamMarczakYT4 жыл бұрын
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_PBI4 жыл бұрын
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 👍
@AdamMarczakYT4 жыл бұрын
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_PBI4 жыл бұрын
@@AdamMarczakYT Great, love to look forward for those content. Keep up the excellent work 👍
@SA-bw1je4 жыл бұрын
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!!!
@AdamMarczakYT4 жыл бұрын
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-bw1je4 жыл бұрын
@@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!!!
@GrabowskiMaciej3 жыл бұрын
dzieki
@AdamMarczakYT3 жыл бұрын
Przyjemnosc po mojej stronie!
@jujubalismel4 жыл бұрын
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!
@AdamMarczakYT4 жыл бұрын
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/
@sid00000094 жыл бұрын
@@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
@jayakrishna91534 жыл бұрын
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
@AdamMarczakYT4 жыл бұрын
Hey Jaya unfortunately I don't share slides at this time. Hope you understand. Best regards!