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))

josef78's avatar
josef78
Icon for Memorable Member rankMemorable Member
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))

jinyuann's avatar
jinyuann
Frequent Visitor
2 years ago

Hi josef78 ,

I tried using web connection. Same thing, It works on my powerbi desktop using windows authentication. But when i try to use windows authentication on my powerbi report server, it says "Log on failed. Ensure the user name and password are correct".

Could it be because I am using the corporate own internal network hence there are some authentication issue when connecting to the report server and sharepoint on prem?

My power BI version: 2.112.1421.0 64 bit (Jan 2023).

  • josef78's avatar
    josef78
    Icon for Memorable Member rankMemorable Member
    2 years ago

    I do not know... maybe check if you are using full login name (from PBI Desktop it may work only with loginname, but server need full format domain\loginname or loginname@domain.
    Also you can try install power bi desktop on same server where is installed power bi report server, and try connecton here.