We Migrated our Analysis Service from 2012 SP2 to 2016 SP1 CU1. We have PowerBI Desktop reports that do direct query to SSAS Instance
The PowerBI Reports have become extremely slow and times out certain visuals when we run against 2016 SSAS.
Same report run fine against 2012.
The 2016 Instance has double the # of CPUs and Double Memory (128GB)Unable to figure out anything. Have gone through all memory settings etc.
Any assistance is greatly appreciated.
We had the same issue.
Clear the cache in PBI Desktop.
This resolved our problems.
Interesting in that we've just upgraded to SQL 2016 and live connections are definitely slow for even basic queries.
The same query in an Excel Pivot Table against the same cube is noticably faster.
Thanks @v-sihou-msft Please let me know if we can provide additional info. We are more than happy to have a webex as this is affecting our production systems after the upgrade.
HI @v-sihou-msft - Any luck with SQL Team. What we are finding is as soon as we add the measure, it starts clocking. some behavious change with SQL2016 compared to SQL2012 SSAS
I noticed this issue too, we have some simple measures that run great in the Excel connection to SSAS 2014, but in Power BI it maxes out the CPU and it takes about 60 seconds instead of < 1 second.