When pulling data from Salesforce, is there a way to use field labels instead of the field names when using the Salesforce connector? For instance, rather than having a column named "c4g_Lead_Rating__c" I want it to use the Salesforce label "Lead Rating". It's easy to figure out the labels for default columns but the custom field labels in large tables can be tricky if a consistent naming schema wasn't used.
I did run across a Microsoft support article titled "Link to or import data from Salesforce" that talks about how to link Access to Salesforce. However, the connector dialog you get in Access allows for connection string parameters where you can add a USELABEL option so the columns use the field label instead of the field name.
Solved! Go to Solution.
Hi @BuckyKat37 ,
I'm afraid this is not possible, here are some references on Salesforce you can refer to:
Salesforce Analytics for Sales Managers
Connect Salesforce to Power BI: 2 Easy Methods
Also here are some threads that may be helpful:
Salesforce Field not displaying in Power BI Desktop
Can't see a Product field in Salesforce Opportunity Product Object
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @BuckyKat37 ,
I'm afraid this is not possible, here are some references on Salesforce you can refer to:
Salesforce Analytics for Sales Managers
Connect Salesforce to Power BI: 2 Easy Methods
Also here are some threads that may be helpful:
Salesforce Field not displaying in Power BI Desktop
Can't see a Product field in Salesforce Opportunity Product Object
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
223 | |
81 | |
74 | |
73 | |
53 |
User | Count |
---|---|
184 | |
93 | |
83 | |
76 | |
74 |