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.
@@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.
Pls do one logic app video, how to refresh tabular model with logic app
Very soon!
Nicely Explained !
Thanks buddy .... Nicely explained Great vedio!!
My pleasure
thanks ,great video
Thank you 🙏
Hi
From where we can get that Netflix data for practice purpose .
Can I create AAS account from free tier access Azure account
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
why do we need AAS when we can do these in Power bI by extracting data from source?
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.
Any idea how to fix this ,getting same issue on Live or direct query connect
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)
Do you want to check at Power Bi level or AAS level?
@@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.
@@prabhatdass6184 towardsdatascience.com/track-your-azure-analysis-services-processing-times-per-table-f2d3238f81a6
Great!
Wt is automation options?
Basically you need to write a script to automate it!!
nice content..
Stay connected.. thanks for the visit..