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

Schedule Refresh no working on Sharepoint 2010 List using Odata

I've developed a Report and it's working with manually refreshing using Windows Account through Odata using the _vti_bin/ListData.svc url.

If I refresh manually it works fine, but it gives me this error when I try to Schedule in Power BI Service.

"The credentials provided for the OData source are invalid"

 

Any ideas?

 

Thanks for reading

 

Regards

 

Rodrigo

4 REPLIES 4
Super User
Super User

Re: Schedule Refresh no working on Sharepoint 2010 List using Odata

Hi there

If you look in the Power Query Editor there will be a version number, I think off the top of my head if you can change that to Version 15 of the API it might work?

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
Highlighted
rockdrigom Regular Visitor
Regular Visitor

Re: Schedule Refresh no working on Sharepoint 2010 List using Odata

Hello @GilbertQ the options I have are from OData.Feed in Power Query and version support values 3 or 4

😞

Super User
Super User

Re: Schedule Refresh no working on Sharepoint 2010 List using Odata

Ahh apologies I was thinking of getting it via SharePoint Online.

Did it make any difference when you changed the version numbers?

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
rockdrigom Regular Visitor
Regular Visitor

Re: Schedule Refresh no working on Sharepoint 2010 List using Odata

Nothing Changes with version 3 or 4.

I even tried Excel with PowerQuery... everything works until scheduled refresh 😞

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.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

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.

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: 294 members 3,132 guests
Please welcome our newest community members: