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.

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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 279 members 3,013 guests
Please welcome our newest community members: