cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KC
Continued Contributor
Continued Contributor

New CDS features, Power Query Issues

 

 

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”.

5 REPLIES 5
CWesener
Power Apps
Power Apps

Adding @millopis and @AngeloMollamefrom the Power Query team.

Thanks,
Clay.
AngeloMollame
Power Apps
Power Apps

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.

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

KC
Continued Contributor
Continued Contributor

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.

Thanks for the feedback!

 

Some updates:

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (10,482)