We have an on-premises SharePoint server (soon to be O365) that I want to connect to a SharePoint list and get data from for a Power BI dashboard/report. I am successfully connecting, but I get this error message and not sure how to proceed:
"Failed to save modifications to the server. Error returned "OLE DB or ODBC error: [DataFormatError] OData: The format 'application/json;charset=utf-8' is not supported."
Is there anything I can do here?
Thanks for the information.