"Analyze in Excel" and Excel "Quick analysis function" BUG

[Tishchenko]

Hi! My users report that their favorite "Quick analysis function" dot'n work as expected.
After some investigation: this bug appears on models that contain bi-dir cross filter relationships.

Upd. Just test "Quick analysis" function in Excel 2016 + SSAS 2016 (level 1200 with BI-DI) - similar bug.

Seems, problem in Excel or SQL_AS_OLEDB providers than don't suport models crеated in PowerBI Desktop or SSAS 2016 (level 1200) with BI-DI relationship? 

[Eric_Zhang]

@Tishchenko

The snapshot shows some difference however I don't know the language(may be Russian) so I still can get the exact problem.

As the problem occurs in Excel 2016 + SSAS 2016 as well in your test, I think the EXCEL forum would be a better place for your question.

[Tishchenko]

@Eric_Zhang Ok. Thanks. 
Main diffirence in pictures:
#1 after click on "Quick analysis" button in pivot table - excel open windows (green area in pic) with all related dimensions list from model, then user click on dimension and Excel execute magic function "Quick analysis".

#2 this picture show EMPTY list (red area) of cube dimensions. 

Problem:  Excel Quick analysis don't show related dimension list from data models that was created in PowerBI Desktop and SSAS 2016 (1200).

[Eric_Zhang]

@Tishchenko

Thanks for your clarification. 🙂

As the problem is on Excel Quick analysis and not only Power BI Desktop related, I'd suggest you start from Excel side. You can post this problem to a Excel forum.