Using my
Macbook Pro
macOS High Sierra
Version 10.13.3
[BUG] CDS Power Query - Mapping from SharePoint
[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”.
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?
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:
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
39 | |
17 | |
12 | |
4 | |
4 |
User | Count |
---|---|
41 | |
25 | |
24 | |
8 | |
7 |