Using my
Macbook Pro
macOS High Sierra
Version 10.13.3
[BUG] CDS Power Query - Mapping from SharePoint
- SharePoint Choice fields will not surface in the Power Query Mapper.
- Power Query Refresh button - does not refresh with the latest updates from the SharePoint list but instead uses what appears to be the browser cache of data from the initial import. Could only get the new columns and data to appear in Power Query by clearing browser cache and restarting the Chrome browser. Switched to Incognito mode, this seems to help.
- Vague Error message: Load to Common Data Service failed. Details: Generic SQL error.. (Job ID: b4c4d427-c4b6-4887-945d-7b16222484af)
- Same Query different error message on 2nd try: Load to Common Data Service failed. Details: Input string was not in a correct format.. (Job ID: 37a7038c-ee8d-4239-b728-b13bd4aa9db0)
[BUG] CDS Power Query - Mapping from OneDrive - Connect to Data Source
Signed in using my Organizational Account received message: You are currently signed in. Click Next and a Warning message appears: Invalid Credentials , unable to proceed!
[?] CDS Power Query - Mapping from Local Drive - Connect to Data Source
Path does not work , cannot upload Excel data from my MacBook drive. Have not tried this with my Windows machine.
[BUG] Set SharePoint column to a Single line Text field map to Multi select Option Set field:
Vague Error Message:
Evaluation failed for Incident: DataSource.Error: We couldn't parse OData response result. Error: Cannot convert a primitive value to the expected type 'Edm.String'. See the inner exception for more details.
No access to “See the inner exception for more details”.
