cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anders99
Regular Visitor

Re: Connecting to a SharePoint List Office 365 error

Yes this work around works but we can hardly teach users how to do this workaround without getting a lot of issues. This really needs to be resolved as there is so much potential in getting nice reports and dashboards from data stored in SharePoint.

Highlighted
kleinbth
Frequent Visitor

Re: Connecting to a SharePoint List Office 365 error

This error message will been given when a multiple user or multi choice field is empty. When all the fields are filled this error message will not been given

Anders99
Regular Visitor

Re: Connecting to a SharePoint List Office 365 error

Any news on when this bug will be fixed? To be clear it affects both the Power BI desktop client as well as Excel (Power query).

alex Helper I
Helper I

Re: Connecting to a SharePoint List Office 365 error

Thanks for posting the question and the subsequent answer.  Would be great to see this fixed.

NicolaeGP
Frequent Visitor

Re: Connecting to a SharePoint List Office 365 error

Is there any workaround without using the API 14? IF I use that, I don't have my custom lists, those only show up if I am using API 15 which in turn gives me the same error but for another property.

djeepy1 Advocate I
Advocate I

Re: Connecting to a SharePoint List Office 365 error

When I change ApiVersion to 14, SharePoint.Tables() function return nothing !

So I cannot use this workaround. Any other ideas ?

Jean-Pierre Riehl
MVP Data Platform
rgparisoto Helper I
Helper I

Re: Connecting to a SharePoint List Office 365 error

Guys!

I've tryed to chance the version 15 for the 14 and this another error ocurred:

 

Expression.Error: A chave não correspondeu a quaisquer linhas na tabela (In English: The key does not match any rows in the table)

.
Detalhes:
Key=Record
Table=Table

 

 

Has someone any idea about this?

djeepy1 Advocate I
Advocate I

Re: Connecting to a SharePoint List Office 365 error

I found a workaround discussing with a SharePoint colleague. You can explicitly define fields you want to get and exclude the one that generate error.

 

add this parameter on OData query => $select=<fields comma-separated>

 

= OData.Feed("https://XXXXX.sharepoint.com/sites/pop/_api/Web/Lists(guid'abcd-efgh-ijkl-mnop-qrst')/Items?$select=...")

 

You can stay with version 15 API.

Jean-Pierre Riehl
MVP Data Platform
rgparisoto Helper I
Helper I

Re: Connecting to a SharePoint List Office 365 error

Hi @djeepy1!

 

Look at my script (automaticaly generated):

let
Origem = SharePoint.Tables("https://xxxxxxxxx.sharepoint.com/gestao/", [ApiVersion = 15]),
#"xxxxxx" = Origem{[Id="xxxxxx"]}[Items]
in
#"xxxxxx"

 

Where I have to put your command?

 

Tks.

djeepy1 Advocate I
Advocate I

Re: Connecting to a SharePoint List Office 365 error

@rgparisoto

 

You have to use OData.Feed function instead of SharePoint.Tables to reach your list.

I guess this should be :

 

let
  origem = OData.Feed("https://XXXXX.sharepoint.com/gestao/_api/Web/Li​sts(guid'yyyyyy')/Items?$select=zzzzzzz")
in
  origem

where

  • XXXX is your Tenant
  • yyyyy is your list guid (the one you have in your second line - [Id="xxxxxx"])
  • ZZZZ is a comma-separated list of fields you want to get

 

Notice I added feedback to my previous comment. I do not know if it applies to your error / context.

 

Jean-Pierre Riehl

Jean-Pierre Riehl
MVP Data Platform

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors