Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error

[Saadii_360o]

HI Everyone.
so I am using List.Generate function to extract data of unknow number of rows from an API but gives me this error after fetching all the rows.
PFB the URL:
URL: https://vcc-na8.8x8.com/api/stats/agents/{Agent-ID}/activities?n=

Error: Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] The remote name could not be resolved:


Let me know if someone has any idea about this and how to fix it.

Thanks in advance.

[Anonymous]

HI @Saadii_360o,

Can you please share some more detailed information and code about your operations? It should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

In addition, you can also take a look at the following blog to add relative and query options to your web connector if helps:

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query An...

Regards,

Xiaoxin Sheng