cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gra_wang Regular Visitor
Regular Visitor

Error when processing the data in the dataset (salesforce objects)

Seems like every time a column in a salesforce object gets removed or somehow altered, I get this error when attempting a scheduled refresh.

 

Here is an example:

Capture.JPG

The column that was removed from the object was something I don't even use in the data model and yet I have to go and edit the query every time this happens. Is there a way to disregard these changes to salesforce objects and just have scheduled refreshes continue as normal? I can understand if the missing column is used in my data model, but this issue makes scheduled refreshes unreliable.

1 ACCEPTED SOLUTION

Accepted Solutions
pablobarra Regular Visitor
Regular Visitor

Re: Error when processing the data in the dataset (salesforce objects)

Hi @gra_wang

 

You need to remove the steps that are "removing" columns.

 

First get all data as you are doing now, and in an early step you can select the columns you want to use in your report and apply a step that is "Remove other columns". If you need you can edit the step with double click and add columns.

 

The query (M code) will be like this:

_______________

let
Source = Salesforce.Data(),
Account = Source{[Name="Account"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(Account,{"Id", "Name"}),
#"Filtered Rows" = Table.SelectRows(#"Removed Other Columns", each ([Id] = "0010O00001mY123QAC"))
in
#"Filtered Rows"

__________________

 

 

Pablo

1 REPLY 1
pablobarra Regular Visitor
Regular Visitor

Re: Error when processing the data in the dataset (salesforce objects)

Hi @gra_wang

 

You need to remove the steps that are "removing" columns.

 

First get all data as you are doing now, and in an early step you can select the columns you want to use in your report and apply a step that is "Remove other columns". If you need you can edit the step with double click and add columns.

 

The query (M code) will be like this:

_______________

let
Source = Salesforce.Data(),
Account = Source{[Name="Account"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(Account,{"Id", "Name"}),
#"Filtered Rows" = Table.SelectRows(#"Removed Other Columns", each ([Id] = "0010O00001mY123QAC"))
in
#"Filtered Rows"

__________________

 

 

Pablo