Forum Discussion
Performance Issues with SSAS Tabular Model in Excel
Hi rlussky ,
Please check:
1. * Are there best practices I am missing? (i.e. starting with a measure when building a Pivot Table from Analysis Services connection)
Here is a blog about speeding up the Excel queries for Tabular SSAS: Faster Excel Queries For Power BI & Azure Analysis Services | XLCubed Blog. Hope it could help you.
2. * Does Excel always perform poorly with Tabular Models?
In most cases, yes. Excel Pivot Tables query Tabular SSAS using MDX, and sometimes the MDX they generate is not ideal. And response times can be particularly slow where the tables have lots of columns and are large in size.
3. * Do I need a Tabular Model for Power BI and a seperate Multidimensional Model for Excel?
Maybe you can use Power BI for both.😉
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi rlussky ,
Please check:
1. * Are there best practices I am missing? (i.e. starting with a measure when building a Pivot Table from Analysis Services connection)
Here is a blog about speeding up the Excel queries for Tabular SSAS: Faster Excel Queries For Power BI & Azure Analysis Services | XLCubed Blog. Hope it could help you.
2. * Does Excel always perform poorly with Tabular Models?
In most cases, yes. Excel Pivot Tables query Tabular SSAS using MDX, and sometimes the MDX they generate is not ideal. And response times can be particularly slow where the tables have lots of columns and are large in size.
3. * Do I need a Tabular Model for Power BI and a seperate Multidimensional Model for Excel?
Maybe you can use Power BI for both.😉
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Icey - So, would I have to purchase a XLCubed license for each of my ~100 end users for using the method in your link? https://blog.xlcubed.com/2021/02/faster-excel-queries-for-power-bi-azure-analysis-services/
Hi rlussky ,
I know little about XLCubed. If you want to use XLCubed, please contact their support in order for you to get the most accurate information:
If you have any questions about Power BI, please feel free to contact me. I will be happy to help you.😀
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I was really hoping not to have to use third party software with licenses to accomplish better performance using Excel. I guess I will have to train more on Power BI with the end users.