Forum Discussion
Solved
Dataset Refresh Error: 431 - "Request Header Fields Too Large."
We have a several Power BI Service reports that have been refreshing without errors for six months. Recently, we've started getting this msg: An error occurred while processing the data in the d...
. Based on the troubleshooting, Fiddler trace and the error, below are the points which will help you to resolve or reach out to Salesforce for your issue:
- On fiddler I have studied the request headers being sent from your Power Bi to Salesforce and the header has 16470 lines of request being passed to Salesforce.
- The limit set by Salesforce is 16,000 characters and 1000 for the API call to be received so that it can process the request
- The limit is 1000 for the number of calls being made and the character length limit is 16,000 characters for salesforce
- This can be seen on their post as well: apex - How to fix error 431 Request Header Fields Too Large . HTTP CODE[431] in Anonymous Window - Salesforce Stack Exchange
- The iDataReader interface connects your .Net framework to pass the request to the datasource and if the datasource doesn’t respond with the request then it will throw the error
- In summary, you would have to reduce the number of columns that you are writing or adding in your M-Query to resolve this issue
- Once the characters are less than 16,000 characters the issue would be resolved as Salesforce would be able to comprehend those many characters
Hi JDBOS I know this reply is very late. As a workaround, in case you can't refresh again, maybe you can try to test your connection with a 3rd party connector. I've tried windsor.ai, supermetrics (which doesn't have PBI as a destination, so you first have to export to Google Sheets and then export to PBI) and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options