Azure Analysis Services -tabular model best practices

[Anonymous]

Hi team,

I am working on creating a tabular model using Azure Analysis Services.Please let me know the following:

1.General best practice recommendations from Microsoft on creating tabular models.

2.Any restrictions on the total number of tables,KPI's etc that can be created per model.

3.Any best practice recommendations for creating the data model,to be imported inside tabular model.

4.Any best practice recommendations on the number of reports,number of users created inside a tabular model.

5.How to achieve performance optimization on a tabular model?

6.Any best practices/considerations on the procing tier to be used.

Regards

[amitchandak · Accepted solution]

@Anonymous , prefer Start schema , Single direction joins

refer

https://www.bi4all.pt/en/news/en-blog/10-best-practice-tips-to-improve-your-tabular-model-performanc...

https://powerbi.microsoft.com/en-ca/blog/best-practice-rules-to-improve-your-models-performance/

https://docs.tabulareditor.com/te2/Best-Practice-Analyzer.html

[Anonymous]

Hello Team,

Are there any best practices related to Tabular Model Scalability?

Regards