Forum Discussion
Salesforce to power BI data import error
I am trying to load a large dataset from salesforce to Power BI. It works perfect and does not show any error in the power query but while the data is loading into the data tab it shows an error "Failed to save notification to the server. Error returned: 'OLE DB or ODBC error: The base stream is not readable. Parameter name: stream." been trying to solve it for hours and no luck yet. Can know what causes this error? Tried searching online but was notable to find a proper answer for it. This id the error it shows me.
2 Replies
- v-luwang-msft
Community Support
Hi Vinay_M_B ,
Check if this is caused by the following limitation:
You can only retrieve 2000 rows using the Salesforce Reports connector. This limitation is set by Salesforce.
refer：
https://www.innovalleyworks.com/how-to-connect-salesforce-to-power-bi/
https://blog.coupler.io/connect-power-bi-to-salesforce-in-a-few-minutes/
Best Regards
Lucien
I am importing from salesforce objects. So there shouldn't be any limitaions.
