Forum Discussion
Error (431): Request Header Fields Too Large
This issue is caused by too many data fields created in a Salesforce object. A workaround is not to refresh data when connected to the object. After selecting the Salesforce object, click at "Transform Data" button in Power Query. Then select "Choose Columns" button to select the applicable columns in the object. Filter data if necessary before click at "Refresh Preview" button to refresh data. Click at "Close & Load" button to close the Power Query Editor.
Thank you Stephen for responding to my request for assistance. Unfortunately, this solution is not feasible as our IT Support would not allow us to make modifications to registry.
Hello, I know it's been a long timebut just sharing this in case others are hunting for an answer. We also had a salesforce object with 700+ fields and got the same error.. This worked for us as we could cherry pick the fields we wanted (and did not need 700+)
Import as normal and you will have a set of steps that fail at step 2.. Leave step 1 intact and change step two as below in the advance editor to "cherry pick" the fields you want. We found you can have up to 698 before this falls over but if you only need a subset of the fields then this works.
let
Source = Salesforce.Data("https://login.salesforce.com/", [ApiVersion=48]),
#"Removed Other Columns" = Table.SelectColumns(
Source{[Name="Name_of_table"[Data],
{
"Name",
"RecordTypeId"
})
in
#"Removed Other Columns"