What is Azure Analysis Services? How to handle large datasets in Power BI? AAS Tutorial | Azure | 4K

[@sarveshdeshpande1772]

Thanks buddy .... Nicely explained Great vedio!!

[@BIConsultingPro]

My pleasure

[@srinivasuluyarramreddy450]

Pls do one logic app video, how to refresh tabular model with logic app

[@BIConsultingPro]

Very soon!

[@francisjohn6638]

Nicely Explained !

[@srinivasuluyarramreddy450]

thanks ,great video

[@BIConsultingPro]

Thank you 🙏

[@dipakrout7994]

Hi From where we can get that Netflix data for practice purpose . Can I create AAS account from free tier access Azure account

[@BIConsultingPro]

Please download from here: www.kaggle.com/datasets/shivamb/netflix-shows Regarding free tier or pricing, please read here: azure.microsoft.com/en-us/products/analysis-services/#get-started

[@goodMbadM]

why do we need AAS when we can do these in Power bI by extracting data from source?

[@krantikumar894]

Wt is automation options?

[@BIConsultingPro]

Basically you need to write a script to automate it!!

[@DeepakKumar-rh8ps]

We are getting an error while connecting model in power BI with import option - AnalysisServices: Resource Governing: This query uses more memory than the configured limit. The query - or calculations referenced by it - might be too memory-intensive to run. Either reach out to your Analysis Services server administrator to increase the per-query memory limit or optimize the query so it consumes less memory. More details: consumed memory 2048 MB, memory limit 2048 MB.

[@DeepakKumar-rh8ps]

Any idea how to fix this ,getting same issue on Live or direct query connect

[@vijaysingh-hw9sj]

nice content..

[@BIConsultingPro]

Stay connected.. thanks for the visit..

[@prabhatdass6184]

Hello Ajay, 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)

[@BIConsultingPro]

Do you want to check at Power Bi level or AAS level?

[@prabhatdass6184]

@@BIConsultingPro at aas level only. The ask is to check how much time AAS model is taking for a full model refresh , and then with partitions how much time it is taking.

[@BIConsultingPro]

@@prabhatdass6184 towardsdatascience.com/track-your-azure-analysis-services-processing-times-per-table-f2d3238f81a6

[@saikatchakraborty5536]

Great!