Forum Discussion
Identical Table Visual Works In Report #1 & Fails In Report #2 (shared dataset)
That's pretty weird.
When you say a "shared dataset", is Rpt #2 a "thin report" that's live connected to the Rpt #1 dataset or is it a DirectQuery connection?
Regardless, you could try changing your measure to simply
DISTINCTCOUNT ( 'Fact D365'[PolicyNumber] )
I doubt the measure is the issue though. What dataset tables does each of the columns in your table visual come from? Are they all from the same 2,315 rows fact table?
Thanks for your response.
1) For Rpt #2, I believe it's a Live connection.
When I click "Transform data", it doesn't explicitly state the connection is live.
It just says "A DirectQuery connection is required".
(Is there a way to see "Live Connection" explicitly stated?)
Additionally, on the left pane, you can see that Rpt #2 only has access to:
- Report View
- Model View
Since it's using a shared dataset, it has no access to the "Table View".
2) I have replaced my original measure with your measure.
(I agree this should not make a difference, but I did it anyway.)
3) Below is the relevant part of the model for the data I am pulling into the table visual.
- Year comes from 'D Year'
- Agent comes from 'D Agent',
- Partner comes from 'D Partner' (renamed in this thread for security reasons).
- All the remaining fields come directly from 'Fact D365' (Plan, Entity, Street, City, State, Zip & Phone).
Regards,
Nathan
