Reply
Regular Visitor
Posts: 36
Registered: ‎10-03-2015

Hierarchies in Analyze in excel with Direct Query

Creating my first Direct Query Power BI report and testing Analyze in Excel.  I notice that none of my Hierarchies appear in Excel, even though they do when in Cached mode.  Have I done something wrong, or is that expected behavior?  I would like it to work.

Otherwise, I'm optimistic about this approach.

Super Contributor
Posts: 3,017
Registered: ‎08-14-2016

Re: Hierarchies in Analyze in excel with Direct Query

Hi @SHHargrove,

 

>> I notice that none of my Hierarchies appear in Excel, even though they do when in Cached mode. 

Since I'm not very clear your issue, can you share some detail contents?

 

Regards,

Xiaoxin Sheng

Highlighted
Regular Visitor
Posts: 36
Registered: ‎10-03-2015

Re: Hierarchies in Analyze in excel with Direct Query

 

In the images below, you'll see that the Product dimension in Power BI includes a "Products" hierarchy.  However in Excel (using Analyze in excel from the same Power BI dataset) the "Products" hierarchy does not appear.

 

Product Dimension in ExcelProduct Dimension in ExcelProduct Dimension in Power BiProduct Dimension in Power Bi

Super Contributor
Posts: 3,017
Registered: ‎08-14-2016

Re: Hierarchies in Analyze in excel with Direct Query

Hi @SHHargrove,

 

If you try to use the hierarchy which created at database, does it analysis in excel succeed? I think excel can't analysis the hierarchy columns which created in power bi.

 

Regards,

Xiaoxin Sheng

Regular Visitor
Posts: 36
Registered: ‎10-03-2015

Re: Hierarchies in Analyze in excel with Direct Query

 

ExcelExcelThis picture is from Analyze in Excel when not using Direct Query in Power BI.

Clearly the difference is Direct Query.