cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ruthpozuelo
Advisor

Issues connecting to sharepoint

Hi, 

After the latest update, I am having problems connecting to a sharepoint library:

 

DataSource.Error: We couldn't parse OData response result. Error: The property 'SupplierNameId' does not exist on type 'Microsoft.SharePoint.DataService.DrawingMasterItem'. Make sure to only use property names that are defined by the type.
Details:
DataSourceKind=SharePoint
DataSourcePath=http://xxx

 

How can I resolve this?

/Ruth

1 ACCEPTED SOLUTION

Accepted Solutions
ruthpozuelo
Advisor

Re: Issues connecting to sharepoint

Hi @v-qiuyu-msft, @Greg_Deckler

I managed to solve my issue!

 

Here is what I did, I had a supplier name column that had type lookup that i changed to a type choice (created new one) and after that I got that error.

 

I recreated the lookup column, added it to my sharepoint library and voilá! It is working now 🙂

 

/Ruth

View solution in original post

6 REPLIES 6
Super User IV
Super User IV

Re: Issues connecting to sharepoint

Is this a SharePoint list and what is the version? 2010, 2013, 2016, Online? Any info on how many data columns and types that you can provide? I can try to recreate the issue.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Moderator v-qiuyu-msft
Moderator

Re: Issues connecting to sharepoint

Hi @ruthpozuelo,

 

How did you get data from SharePoint Library? In Power BI desktop October update version or Power BI Service? Which data source did you use to get data? Please share more information for us to analyze the issue.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ruthpozuelo
Advisor

Re: Issues connecting to sharepoint

Hi @v-qiuyu-msft

Yes of course,

 

I used Sharepoint.Contents to get the data using the Power BI desktop October update_

 

= SharePoint.Contents("http://xxxx)/", [ApiVersion = 14])

 

Unsure what you mean with "which data source", I am importing data from sharepoint 2010 using sharepoint.contents.

 

Does this help?

/Ruth

ruthpozuelo
Advisor

Re: Issues connecting to sharepoint

Hi @Greg_Deckler,

 

Sharepoint 2010. I get the error in the navigation step already...

 

2016-11-02_12-27-31.png

 

/Ruth

ruthpozuelo
Advisor

Re: Issues connecting to sharepoint

Hi @v-qiuyu-msft, @Greg_Deckler

I managed to solve my issue!

 

Here is what I did, I had a supplier name column that had type lookup that i changed to a type choice (created new one) and after that I got that error.

 

I recreated the lookup column, added it to my sharepoint library and voilá! It is working now 🙂

 

/Ruth

View solution in original post

Super User IV
Super User IV

Re: Issues connecting to sharepoint

Cool, glad you got that resolved! That's a weird issue!


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors