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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mattanchor1
New Member

Salesforce Integration - Filter based on Salesforce Field

Hi,

Apologies in advanced if this is posted to the wrong forum...

 

I have integrated PBI successfully into Salesforce, but I'm having an issue trying to filter based on a value of a field of the Record you're in, in Salesforce. 

 

I have created a custom formula (text) field in Salesforce as a Filter and it works if I use a static value: 

"View/contact_id eq '123456789'"

 

But ideally, I would like the PBI report to filter dynamically based on the Contact ID field value of the Contact you select in Salesforce: 

"View/contact_id eq 'Contact_ID__c'"

 

1 REPLY 1
lbendlin
Super User
Super User

Seems to work for others - you may need to place your quotes differently

 

Solved: Salesforce URL link to open and filter Power BI fi... - Microsoft Fabric Community

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.