使用SSAS多维数据集的Power BI Slow [英] Power BI Slow with SSAS Multidimensional Cube
问题描述
我们正在通过SSAS多维数据集直接查询实现Power BI。出于某种原因，SSAS Power BI的性能极慢，但是使用SSDT SSAS Application或Power View或Excel则要快得多。
We are implementing Power BI with SSAS Cube Direct Query. For some reason, SSAS Power BI is extremely slow performance, however using SSDT SSAS Application or Power View or Excel is Much faster.
我读到Power BI可以转换SSAS多维模型通过将MDX转换为DAX查询。是否有任何方法可以加快针对SSAS的Power BI查询或直接使用MDX查询？
I read that Power BI converts SSAS Multidimensional models by converting MDX to a DAX query. Is there any method to speed up Power BI queries for SSAS, or use MDX queries directly?
我们正在应用SSAS多维模型。
推荐答案
我不认为性能问题是由于将MDX转换为DAX 因为直接查询不会转换查询。另一方面，直接查询具有许多局限性，并且不总是建议。
I don't think that the performance issue is caused by converting MDX into DAX since Direct Query doesn't convert the query. On the other hand Direct Query has many limitations and it is not always recommended.
两年前，Power BI团队创建了一个用于改进直接查询的主题
Two years ago, the Power BI team created a topic for improving Direct Query
我不认为有通用案例的直接解决方案（将SSAS多维与Power BI结合使用），但是您必须阅读有关直接查询限制，最佳实践和用例的更多信息。
I don't think there is a direct solution for a generic case (using SSAS Multidimensional with Power BI), but you must read more about the Direct Query limitations, best practices and use cases.
参考以下官方文档，有一些使用直接查询的最佳实践：
Referring to the following official documentation, there are some best practices for using Direct Query:
- DirectQuery best practices
参考文献和有用的文章cles
- 使用Power BI直接查询
- 在#powerbi和#ssas #tabular <中使用和优化DirectQuery / a>
- 在Power BI中使用DirectQuery
- DirectQuery简介
- Direct Query with Power BI
- Using and optimizing DirectQuery in #powerbi and #ssas #tabular
- Using DirectQuery in Power BI
- Introduction to DirectQuery
这篇关于使用SSAS多维数据集的Power BI Slow的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
