Forum Discussion
Schedule Refresh Error on Salesforce Table - Expanded Columns
I am linking to one Salesforce object, and within that object I have two columns that need to be expanded to pull one field each. All working well using Power BI desktop and manual refreshes in the a...
Anonymous
You may check if the following post helps.
Hello,
It doesn't seem to be the same issue. In my case it is the expanded columns that spring the error in the Power BI service. Again, not happening with refresh in the desktop client. Here is the first part of my query that is causing the error:
let
Source = Salesforce.Data("https://login.salesforce.com/", [CreateNavigationProperties=true]),
Opportunity = Source{[Name="Opportunity"]}[Data],
#"Expanded RecordType" = Table.ExpandRecordColumn(Opportunity, "RecordType", {"Name"}, {"RecordType.Name"}),
#"Expanded Owner" = Table.ExpandRecordColumn(#"Expanded RecordType", "Owner", {"Name"}, {"Owner.Name"}),