Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm able to connect and refresh data from Salesforce using my local Power BI client, but when I publish and schedule a refresh I get the following error:
Last refresh failed: Thu May 11 2017 17:25:29 GMT-1000 (Hawaiian Standard Time)
There was an error when processing the data in the dataset.Hide details
Data source type: | |
Processing error: | The column 'Included_in_most_recent_quarterly_FCST__c' of the table wasn't found. |
Unlike other posts with the same error, this column is not explicitly referenced in Query Editor / Advanced Editor. I think it's implicitly getting referenced in this statement:
Historical_Opps_With_Payment__c = Source{[Name="Historical_Opps_With_Payment__c"]}[Data],
Is there a way to specify which columns I want from Source{[Name="Historical_Opps_With_Payment__c"]}[Data] instead of loading the whole table?
Here's the full query:
let Source = Salesforce.Data(), Historical_Opps_With_Payment__c = Source{[Name="Historical_Opps_With_Payment__c"]}[Data], #"Added Custom" = Table.AddColumn(Historical_Opps_With_Payment__c, "cKey", each DateTime.ToText([CreatedDate])&[Opportunity_Name_ID__c]&[Fiscal_Year_P_S__c]), #"Added Conditional Column" = Table.AddColumn(#"Added Custom", "cRecordCapturedOn", each if [RecordCaputuredOn__c] = null then [CreatedDate] else [RecordCaputuredOn__c] ), #"Changed Type" = Table.TransformColumnTypes(#"Added Conditional Column",{{"cRecordCapturedOn", type date}}) in #"Changed Type"
Here's what I've tried so far:
Additional context:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.