Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
ashrafshaheed
New Member

PBI Report Server failing to authenticate sharepoint credentials

Hello

 

i am trying to pick an excel doccument from onedrive,analyse it in powerbi and add it to scheduled refresh however when i put my windows credentials for the share point data source i get an error of incorrect username and password,i have read through all your posts on such an issue but i still can't figure it out

2 REPLIES 2
d_gosbell
Super User
Super User

Unfortunately OneDrive is not listed as a supported data source (see https://docs.microsoft.com/en-us/power-bi/report-server/data-sources) I imagine it falls into the same situation as Sharepoint online lists, where you can connect with the Desktop client but cannot schedule a refresh. I believe this might be due to the fact that the on-prem report server does not have the integration with the cloud authentication mechanisms.

Thank you for the response.

How about if i also tried accessing the file from the Organisation sharepoint folder but when i tried to refresh,it would still show that the credentials for the sharepoint data source are incorrect.I was using my windows credentials.

 

If it's not possible,please recommend an online collaborative tool that works perfectly with powerbi shceduled refresh.I tried smartsheet but it also doesnt work with scheduled refresh.

 

Please help

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.