Forum Discussion

ashwinkolte's avatar
ashwinkolte
Helper III
2 years ago
Solved

Issue with Drill through

Hi .. I am facing this issue with Drill through . Appreciate any help with this. Please note the source is Microsoft OneLake 

 

I have a bar chart created using a measure (called NUM_TASKS). I have created a new page and specified this measure as the drill through field shown below in second image . However when I right-click on any of the bar , the option to drill through doesnt appear as shown in first image below  .  . Has this anything to do with the source (OneLake) ?

 

 

 

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ashwinkolte 

     

    Anonymous Thank you very much for your prompt reply, please allow me to share some content here.

     

    This problem should have nothing to do with the data source.


    You can check by following these steps:

     

    OneLake should generally support drill down, but make sure the data source is properly connected and there are no issues with data refresh or permissions.

     

    Make sure that the field for drilling (measure) exists in both the main report page and the drill page.

     

     

     

    This should allow you to Drill through.

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    ashwinkolte Do you have the NUM-TASKS measure in the Drill through well of the source page too?

     

    • ashwinkolte's avatar
      ashwinkolte
      Helper III
      2 years ago

      HI Anonymous  Thankyou so much for quick response 

       

      I am not using on object ineraction option. But I do get the below (see image) on clicking any visual on the source page including this one for which I have drill through page. But adding here makes the source page itself a drill through page (ccreates the left arrow with circle at the top) . , which is not intended . And it doesnt work  anyway

       

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ashwinkolte 

     

    Anonymous Thank you very much for your prompt reply, please allow me to share some content here.

     

    This problem should have nothing to do with the data source.


    You can check by following these steps:

     

    OneLake should generally support drill down, but make sure the data source is properly connected and there are no issues with data refresh or permissions.

     

    Make sure that the field for drilling (measure) exists in both the main report page and the drill page.

     

     

     

    This should allow you to Drill through.

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.