Forum Discussion

jinyuann's avatar
jinyuann
Frequent Visitor
2 years ago
Solved

Sharepoint On-Prem Connection Issue in Power BI Report Server

Hi, I have checked your website https://learn.microsoft.com/en-us/power-bi/report-server/data-sources saying that sharepoint file (on premises) is supported for scheduled refresh. Hence in my Powerbi...
powerbi
  • josef78's avatar
    josef78
    2 years ago

    I'm not sure with SharePoint files connection, but I'm refreshing data from on-prem SharePoint using standard "Web" connection (with sharepoint URL to specific file), and it is working well (using Windows authentification and full username (with domain name))

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi jinyuann ,

Please refer to.

Power BI report scheduled refresh in Power BI Report Server - Power BI | Microsoft Learn

 

If it still does not help, could you provide a bit more information to further diagnose the problem:

- What version of the Power BI Report Server are you using?
- Are there any specific error codes or messages, besides the general logon failure, that you can share?
- Have you been able to successfully use scheduled refresh with other data sources in the Power BI Report Server?

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jinyuann's avatar
jinyuann
Frequent Visitor
2 years ago

Hello Rongtie, I do not think that my report contains any dynamic data source. Its basically just an excel file is stored in my documents sharepoint.

 

- What version of the Power BI Report Server are you using?

Will let you know again which version that i am using though i do not think that the version of the powerbi report server will affect the compatibility of connecteing to the sharepoint unless i am wrong.
- Are there any specific error codes or messages, besides the general logon failure, that you can share?

No, In my report server, i just go under manage data source > windows authentication > enter my credentials and it just says that "Log on failed. Ensure username and password are correct". The credentials i used is the same as what i used when i using powerbi desktop.
- Have you been able to successfully use scheduled refresh with other data sources in the Power BI Report Server?

Yes, I have used Excel.Workbook(...) to retrieve the file from my shared network drive. and also retrieve data from SQL in my report server. Its just the sharepoint one that i am unable to connect