Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Courtland Ferro]

Hi All,

I know the drillthrough feature is frustrating for many of us, the right click feature many times doesn’t fit the stakeholders requirements.

However, I have noticed that there is a drillthrough feature on the top editing bar, when this is turned on, a user can left click and the drillthrough options will appear (see photo below)

The issue I am having here is when I upload this report online, this drillthrough feature turns off. I have tried turning this feature back on once the report is published, but it seems to automatically turn off every time the page is refreshed.

Does anyone have a solution to this? Or does anyone know another solution to drillthrough that does not include right-clicking? Thanks

——————————
Courtland Ferro
——————————

[Christoph Spieles]

Hi ,

check out this link, if you haven’t already: https://docs.microsoft.com/en-us/power-bi/desktop-cross-report-drill-through
It describes setting it up both in Desktop and the web service, and what to keep in mind. Maybe it’s referring to a report in another workspace?

Hope it helps, otherwise let us know here.

Best,
Chris

——————————
Christoph Spieles
Senior BI Developer & Analyst

Berlin Power BI User Group Meetup Organizer
https://www.meetup.com/de-DE/Berlin-Power-BI-User-Group/
——————————
——————————————-

[Sam Duval]

You can leverage URL parameters and create a drill through hyperlink instead of the drill through context menu. I just stumbled across this guy in a cube video where he shows a (new?) feature that lets you turn any column into a hyperlink. So you could leverage existing columns in your table or create a new one that is “click here for Owner” or “click here for Arch” etc…

https://youtu.be/Wz2aD0XvkUk 

?

——————————
Sam Duval
Data Quality Analyst
Indianapolis
——————————
——————————————-

[Courtland Ferro]

Sam,

This looks great, do you know how I could leverage url parameters and allow them to let me click the link and take me to a new page in the report.

Thanks

——————————
Courtland Ferro
——————————
——————————————-

[Audrey Abbey]

Courtland,

That’s sounds like a bookmark to me.

——————————
Audrey Abbey
SR. BI Developer/Analyst
LeapFrogBI
Portland OR
——————————
——————————————-

[Courtland Ferro]

Hi Audrey,

How would a bookmark eliminate the right click drillthrough? I am looking to have the stakeholder be able to click on a field in a table and have them taken to the new report page.

Thanks

——————————
Courtland Ferro
——————————
——————————————-

[Audrey Abbey]

Set the bookmark to be the URL of the page you want to go to.

——————————
Audrey Abbey
SR. BI Developer/Analyst
LeapFrogBI
Portland OR
——————————
——————————————-

[Courtland Ferro]

do you have any examples of this? I am sort of confused. Thanks ?

——————————
Courtland Ferro
——————————
——————————————-

[Courtland Ferro]

I have tried what you sent me and when I click on the url, it opens up a new web tab with the report view. Is this the intended result? Is there a way to just modify the report view in the same web page?

Thanks ?

——————————
Courtland Ferro
——————————
——————————————-

[Sam Duval]

Yes, at least in that has been my experience as well. I use it mostly as a jump from PBI to paginated, so I haven’t had anyone complain about the new tab. I’ll poke around and see if I can find anything about changing the new tab behavior. But it might just be a handicap we are stuck with for now. Not the best user experience but not the worst either. The benefit of a new tab is they don’t need a way to “go back”, they just close the “drill through” and they are back on the main page and can view the next section.

——————————
Sam Duval
Data Quality Analyst
Indianapolis
——————————
——————————————-