Issue with Drill through

[ashwinkolte]

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) ?

[v-nuoc-msft · Accepted solution]

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.

[Anonymous]

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

[ashwinkolte]

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