Skip to main content

Power BI

New

Keep/Allow Hierarchy Filters (in Excel) in Direct Query Mode

Vote (12) Share
Henrik's profile image

Henrik on 23 Jan 2019 20:28:02

When accessing power-bi data with excel, existing hierarchy filters are also usable in Excel. This does apply for manual created hierarchy filters as well as with automated hierarchy filters (e.g. in Dates).

However this feature is not working as soon as you have at least one table with direct query mode. In this case all hierarchy filters are gone.
Therefore the request is, that also in direct query mode the hierarchy filters should be available (at least for the tables still in import mode).

Besides this current behaviour should be documented.

Comments (1)
Henrik's profile image Profile Picture

dded71da ea81-42cb-aa4d-601b6fccc56c on 06 Jul 2020 00:04:29

RE: Keep/Allow Hierarchy Filters (in Excel) in Direct Query Mode

I don't understand the technical difficulty for making this possible.
It's super useful and as long as we have it for excel source it's more than reasonable to have it for direct query.