Schedule Refresh no working on Sharepoint 2010 List using Odata

[rockdrigom]

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

[VikasMattela]

@rockdrigom Is your problem resolved. Even I am facing the same issue.

[GilbertQ]

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?

[rockdrigom]

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

😞

[GilbertQ]

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

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

[rockdrigom]

Nothing Changes with version 3 or 4.

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