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

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

Have any of you found the source of the performance issue? 

ASHOKKPIN Regular Visitor
Regular Visitor

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

Hi  - Based on the analyis and Inputs from microsoft - there has been a change in the way DAX from PowerBI generates/runs on SSAS 2016 MDX instances. This change was done because of a bug in earlier versions where it produced incorrect results.

 

This fix while ensures that results are accurate, in certain edge cases results in slow query performance and timeouts.

 

At this point there is no resolution to the issue other than

 

1. Try not to create reports that are very wide in Power BI.

2.Use SSRS for such reports

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 140 members 1,487 guests
Please welcome our newest community members: