Does drill through work with Dataverse?

[luvagoldenk9]

Hello,

Have a PBi report that uses a sharepoint list as the data source - the Share Point list id field is the drill through and included in the table  - 'Drill through' appears when the line item is right clicked:

Have a second PBi that uses Dataverse as the data source -  the Dataverse id field is the drill through and included in the table  - 'Drill through' does not appear when the line item is right clicked:

Has anyone used drill through on Dataverse and if yes, did you do something different to get the 'Drill through' option to appear?

Thank you.

[luvagoldenk9 · Accepted solution]

I changed the field from the Dataverse id field (which is a text field) to the Dataverse Campaign Name (text) field and the Drill through worked. Both the Campaign Name and the id fields are in the table. Not sure why it worked now but posting this complete.