Forum Discussion

PowerNooby's avatar
PowerNooby
Frequent Visitor
3 years ago
Solved

Error (431): Request Header Fields Too Large

I am also encountering error message "(431): Request Header Fields Too Large" when I select Opportunity Object from Power Query (from Power BI Desktop and Excel). I had reviewed the posts on similar...
Need Help
  • PowerNooby's avatar
    PowerNooby
    2 years ago

    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.

danielcontente's avatar
danielcontente
Helper II
2 years ago

Hi, did you manage to solve it?
I am having the same issues...

 

PowerNooby's avatar
PowerNooby
Frequent Visitor
2 years ago

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.