SSAS drilldown query for PowerBI

François Leblanc (CIUSSS NIM) 21 Reputation points
2021-10-13T15:16:33.707+00:00

I am trying to use a drilldown avalaible in a cube made in 2008R2 with PowerBI. Does this feature is avalaible? How can i do that? I looked on the net, but all i find is how to do drilldown in powerBI. Wich is not what i'm looking for.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,244 questions
Accepted answer
  1. CarrinWu-MSFT 6,851 Reputation points
    2021-10-14T05:59:57.75+00:00

    Hi @FranoisLeblancCIUSSSNIM-3385,

    Welcome to Microsoft Q&A!

    Sorry about that I don't have experience with SSAS 2008R2. But based on my research, the drill down feature is deprecated from the cube browser. You can't enable it in the browser. You just can connect to your cube from Excel or Power BI to get drill down feature.

    Best regards,
    Carrin

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Patrick 426.1K Reputation points MVP
    2021-10-13T15:18:05.567+00:00

    The product group for Power Bi actively monitors questions over at
    https://community.powerbi.com/

    --please don't forget to upvote and Accept as answer if the reply is helpful--