New CDS features, Power Query Issues

[KC]

Using my 

Macbook Pro

macOS High Sierra

Version 10.13.3

[BUG] CDS Power Query - Mapping from SharePoint

1. SharePoint Choice fields will not surface in the Power Query Mapper.
2. 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.
3. Vague Error message: Load to Common Data Service failed. Details: Generic SQL error.. (Job ID: b4c4d427-c4b6-4887-945d-7b16222484af)
4. 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”.

[CWesener]

Adding @millopis and @AngeloMollamefrom the Power Query team.

[AngeloMollame]

1. SharePoint Choice fields. Can you please clarify what you mean by Choice fields?

2. Power Query Refresh button does not show latest data. We're investigating on this issue.

3. Vague Error message and 4. Same Query different error message on 2nd try. Were you trying to load text into an Option Set field? That is currently not supported, but will be supported later on. As a workaround for now, you can replace the text values with the corresponding numerical values 0, 1, 2, etc.: select the column, right-click, Replace Values.

[BUG] CDS  Power Query - Mapping from OneDrive - Connect to Data Source. We're investigating on this issue.

CDS Power Query - Mapping from Local Drive - Connect to Data Source. Loading from a local file requires an On-Premise Data Gateway (https://powerbi.microsoft.com/en-us/gateway/) which unfortunately is only available for Windows.

Set SharePoint column to a Single line Text field map to Multi select Option Set field. Loading text into an Option Set field is currently not supported, but will be supported later on. As a workaround for now, you can replace the text values with the numerical values 0, 1, 2, etc.: select the column, right-click, Replace Values.

[AngeloMollame]

[BUG] CDS  Power Query - Mapping from OneDrive - Connect to Data Source. Are you using OneDrive Personal or OneDrive for Business?

[KC]

Hi Angelo,

Sorry for my delayed response.

1. SharePoint Choice field -  Create Column - Column Type:  Choice (menu to choose from)

3. Vague Error message and 4. Same Query different error message on 2nd try - Were you trying to load text into an Option Set field? Yes

Workaround - This worked, thank you

OneDrive -  this is my dev tenant, I thought this was One Drive for Business but the url says Personal, yet when I go to the One Drive Admin center it says One Drive for Business. ?

Just want you to know, all the hard work you all are putting into these great tools is much appreciated.

[AngeloMollame]

Thanks for the feedback!

Some updates:

• SharePoint Choice fields. We're investigating on the issue.
• OneDrive. We only support OneDrive for Business. This article provides some tips for coming up with the URL: https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links.