programsam
Board Regular
- Joined
- Feb 10, 2016
- Messages
- 123
I don't see a lot from Salesforce/Power Query questions here but I have the following M in Power Query to pull data in from Salesforce custom table 'SR__c'. The table has a nested relationship table named 'RO__r' as placed in bold below.
When I try to expand the relationship table ('RO__r'), it will not expand and I've tried adjusting data load options as researched here and in the Microsoft community. I really only need two columns from 'RO__r', is it possible to modify the M code below to have Power Query open RO__r and bring in those two columns and do so more expeditiously?
When I try to expand the relationship table ('RO__r'), it will not expand and I've tried adjusting data load options as researched here and in the Microsoft community. I really only need two columns from 'RO__r', is it possible to modify the M code below to have Power Query open RO__r and bring in those two columns and do so more expeditiously?
Excel Formula:
let
Source = Salesforce.Data("https://xxxxxx.salesforce.xxxxxx.com", [CreateNavigationProperties=true]),
SR__c = Source{[Name="SR__c"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(SR__c,{"Name","CreatedDate","SN__c","Customer__c","Customer_Num__c","Vend__c","MRS__c","MRR__c","MS__c","MR__c","QB__c","IS__c","IPS__c","IS__c","IC__c","CPR__c","PGII__c",**"RO__r"**})
in
#"Removed Other Columns"