cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DebbieE Power Participant
Power Participant

Drill through to another Report (Cross Report) not working

This is the first time I have attempted to drill though from one Report (pbix file) to another.

 

So I have a report with a visual on it with a surveyID (Main Report)

On the Page I have cross repot set to On.

I have gone into Options > Report Settings and set Allow Visuals in this report to use drill through to on

 

Then I have another report.  (Sub Report)

In Drill through I have surveyID. Cross Report is on

I have gone into Options > Report Settings and set Allow Visuals in this report to use drill through to on

 

I have published both reports and gone to the top report. Right clicked on the visual but no drill through.

 

I know that the SurveyID Im drilling down on from the table in Report A exists in the tables for Report B because Ive checked.

 

Drillthroughissuemodel.JPG

This is a digram (Example) of the back end data. 

 

 

 

What can be going wrong?

2 ACCEPTED SOLUTIONS

Accepted Solutions
asaha3
Frequent Visitor

Re: Drill through to another Report (Cross Report) not working

The DIM table in the 1st report with the survey ID needs to be in the 2nd report and be exactly the same. And then create the model from that table.

View solution in original post

Community Support
Community Support

Re: Drill through to another Report (Cross Report) not working

Hi @DebbieE ,

 

There is an article about cross-report drillthough, pay attention to the key steps in it : https://docs.microsoft.com/en-us/power-bi/desktop-cross-report-drill-through.

 

For example:

>> Make sure that:

Fields you want to pass exist in both data models.

The names of the fields, and the names of the tables to which they belong, are identical (the strings must also match, and are case-sensitive).

 

Best Regards,

Amy

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

View solution in original post

5 REPLIES 5
Super User III
Super User III

Re: Drill through to another Report (Cross Report) not working

Hi @DebbieE ,

 

Have you turn on drill trhough on the report level in the PBI web service?

 

Check this video from Guy in the Cube and check out from 5:30 onward you need also to activate the option on the web report.

 

https://www.youtube.com/watch?v=OcZr_70OGPo

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Check out my blog: Power BI em Português


DebbieE Power Participant
Power Participant

Re: Drill through to another Report (Cross Report) not working

Great video as usual from these guys. Ive check and drill through is on in the service for both reports so this isnt this issue

asaha3
Frequent Visitor

Re: Drill through to another Report (Cross Report) not working

The DIM table in the 1st report with the survey ID needs to be in the 2nd report and be exactly the same. And then create the model from that table.

View solution in original post

DebbieE Power Participant
Power Participant

Re: Drill through to another Report (Cross Report) not working

Ahhh,

 

I thought that might be the case. Thanks 

 

Debbie

Community Support
Community Support

Re: Drill through to another Report (Cross Report) not working

Hi @DebbieE ,

 

There is an article about cross-report drillthough, pay attention to the key steps in it : https://docs.microsoft.com/en-us/power-bi/desktop-cross-report-drill-through.

 

For example:

>> Make sure that:

Fields you want to pass exist in both data models.

The names of the fields, and the names of the tables to which they belong, are identical (the strings must also match, and are case-sensitive).

 

Best Regards,

Amy

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

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors