Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Sharepoint excel refresh in Power BI Report server

HI I have an excel file is in my sharepoint site. i can add it via web source and authentication i used is org account in Power BI desktop.   Schedule refresh works fine in Power BI service.   W...
Need Help
PBIRS
PBIRS Data Source
Power BI Report Server
Refresh
Report Server
Anonymous's avatar
Anonymous
Not applicable
5 years ago

As per Microsoft web source is allowed for schedule refresh.

and my source looks like below in PBIRS.

Pragati11 

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi Anonymous ,

 

Can you confirm if you are using sharepoint online or Web connection?

 

Based on your original question, you mentioned you are using Sharepoint online connection which is not supported in PBRS:

 

Thanksm

Pragati

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Pragati, Pragati11 
    i am using a web connection as i showed above, i am pulling a excel data from sharepoint and using a web connection.

     

    In power bi desktop it works with organization account authentication to fetch data,.

     

    and when i publish the same report in PBIRS, we have only these 3 options, Anonymous, Basic and widnows authentication.

     

    I tried all 3 but none of them are not allowing me to connect to the same web connection which i can in power bi desktop.

     

    Kindly advise. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Pragati11 Pragati any update on this please?