cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ronnoc
Advocate II
Advocate II

Sharepoint list showing as on-premise and not refreshing

Hi everyone, thanks for all the support so far from the community.

 

My datasets from sharepoint online are showing up as 'SharepointListOnPremise' under data source credentials in the PBI service and now they wont refresh the error specifically says that the data source can't be refreshed because the credentials are invalid.. However it provides no valid options to set the credentials.

 

Strangely past datasets still work fine its only newly created ones that keep showing up as 'on premise' and wont refresh despite following the exact same process as always.

 

Is the powerbi service currently under maintenance or has support for sharepoint been dropped??

 

I would sincerely appreciate any help or input on this.

 

a1.PNGa2.PNG

6 REPLIES 6
ronnoc
Advocate II
Advocate II

Big thanks to everyone in the community who has provided useful answers so far.

 

I have created and published a new project with a dataset stored on sharepoint online. Suddenly I am having trouble with the following error in PBI service when attempting to refresh the dataset:

 

a1.PNG

 

The data added via sharepoint folder was imported into PBI desktop the same way as always without any errors. My past data sets from sharepoint still work perfectly and show functional credentials for the data source (as seen here):

 

a3.PNG

My newly created project (as of today) shows an error here and a data source of "SharepointListOnPremise" which is not true at all as the data is definitely stored online in the same location as the other functional datasets in my PBI service.

 

a2.PNG

Today I 'synced' the files on the Sharepoint directory with my machine and I am sure thats what has caused the issue. However I have deleted the entire directory, cancelled the syncing of sharepoint and recreated an entirely new project and data set to find the exact same issue now recurring...

 

I am very confused about whats happened here as the same reliable process of importing sharepoint data has suddenly yielded an entirely unfamilar result.

 

Please help me out here, any responses are appreciated

afs_dubon
New Member

I have the same issue...

v-haibl-msft
Microsoft
Microsoft

@ronnoc

 

What authentication methods can you see after you click edit credentials? Is OAuth available in the method list?

Same issues have already been reported. I’ll keep an eye on them and post here if there is any update.

 

Invalid credentials on Sharepoint folder_1.jpg

 

Best Regards,

Herbert

I'm experiencing the same issue. Would be good if we get an update about this soon.

Anonymous
Not applicable

I am having exactly the same issue. Hope getting a solution for this soon. I have been struggling with OneDrive Business excel files to stay in sync with PBI.com for 2 days and thank god I found this Chris Webb post (http://www.excelguru.ca/blog/2016/09/07/get-data-from-onedrive-for-business/) to arrive to that solution, which seems the smartest. But at the moment this solution is not deliverable while the update cant be done. Please, we need some support in this!

 

Thanks

Regards

 

Fran

Thanks for your help Herbert,

 

OAuth is not available in the list. My list is exactly the same as in the photo you posted.

 

Cheers,

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!