Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
@Anonymous , prefer Start schema , Single direction joins
refer
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 , prefer Start schema , Single direction joins
refer
https://powerbi.microsoft.com/en-ca/blog/best-practice-rules-to-improve-your-models-performance/
https://docs.tabulareditor.com/te2/Best-Practice-Analyzer.html
Hello Team,
Are there any best practices related to Tabular Model Scalability?
Regards