cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anders99 Frequent Visitor
Frequent 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.

kleinbth Frequent Visitor
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 Frequent Visitor
Frequent 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 Regular Visitor
Regular Visitor

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
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 Frequent Visitor
Frequent Visitor

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 Frequent Visitor
Frequent Visitor

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 Frequent Visitor
Frequent Visitor

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 Frequent Visitor
Frequent Visitor

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.

Highlighted
djeepy1 Frequent Visitor
Frequent Visitor

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
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 245 members 2,613 guests
Please welcome our newest community members: