cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ASHOKKPIN Regular Visitor
Regular Visitor

PowerBI Desktop against SSAS 2016 Live query extremely slow and timesout

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.

MSDN Query Posted

11 REPLIES 11
Pfister Established Member
Established Member

Re: PowerBI Desktop against SSAS 2016 Live query extremely slow and timesout

Hi Ashokkpin

We had the same issue.

Clear the cache in PBI Desktop.

This resolved our problems.

 

Greetings Hp Pfister
Power Query Buch online auf http://www.powerbi-pro.com
ASHOKKPIN Regular Visitor
Regular Visitor

Re: PowerBI Desktop against SSAS 2016 Live query extremely slow and timesout

Thanks Pfister. Unfortunately that did not help. Issue is persisting in PowerBI.com as well

Phil_Seamark Super Contributor
Super Contributor

Re: PowerBI Desktop against SSAS 2016 Live query extremely slow and timesout

Are they Tabular or MDX cubes?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

ASHOKKPIN Regular Visitor
Regular Visitor

Re: PowerBI Desktop against SSAS 2016 Live query extremely slow and timesout

They are all MDX

Highlighted
Phil_Seamark Super Contributor
Super Contributor

Re: PowerBI Desktop against SSAS 2016 Live query extremely slow and timesout

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.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Moderator v-sihou-msft
Moderator

Re: PowerBI Desktop against SSAS 2016 Live query extremely slow and timesout

@ASHOKKPIN@Phil_Seamark

 

We have reported this issue to SQL Team internally.

 

Regards,

 

ASHOKKPIN Regular Visitor
Regular Visitor

Re: PowerBI Desktop against SSAS 2016 Live query extremely slow and timesout

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.

ASHOKKPIN Regular Visitor
Regular Visitor

Re: PowerBI Desktop against SSAS 2016 Live query extremely slow and timesout

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

daandamhuis Regular Visitor
Regular Visitor

Re: PowerBI Desktop against SSAS 2016 Live query extremely slow and timesout

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.