The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi all,
When running a custom connector in a small environment against azure graph API I receive no errors. I then tested the connector in a larger environment and I receive the following:
OLE DB or ODBC error: [DataSource.Error] OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host..
I've tried limiting the rows returned, which somewhat works, but the results have been inconsistent. Any assistance is appreciated!
HI @jasonrutherford,
I agree with lbendlin 's point of view. You can check the limitations of azure graph API usage if some of the requests have been blocked.
Microsoft Graph throttling guidance
You can also take a look at the following blog about a similar issue if it helps:
Regards,
Xiaoxin Sheng
Does your company have hourly API call limits for the graph API? Have you tried adding a delay in between calls?
User | Count |
---|---|
6 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
9 | |
7 | |
6 | |
5 | |
4 |