Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Cross Report Drillthrough not working with CSV files

Hi all,

 

I created a source and a target report which both use a SQL query to get some data and set up the cross report drillthough successfully. It works like a charm in the Power BI service.

 

Now I did exactly the same using a CSV file as the source data (and in fact used a copy of the source report to create the target report so that the table name as well as all column names match exactly). I set up the drillthrough in the same way I did when using the SQL sources, uploded both reports to the same workspace as before - which is not "My Workspace" - and it does not work. From my point of view all 2 reports are very similar but just the conection to the source data is different.

 

Is this cross report drillthrough not working with all data connectors or am I missing something else?

 

Would highly appreciate some help. Thanks,

Jens

 

1 REPLY 1
lbendlin
Super User
Super User

The connectors don't matter.  The query output matters.  Double and triple check that your column and table names match exactly (including case sensitivity and trailing spaces) between the two datasets.

 

Use cross-report drillthrough in Power BI Desktop - Power BI | Microsoft Learn

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.