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

Pragati11 it is a sharepoint excel and i am connecting to it as a web data source. it works fine in Power BI service. but i want that in PBIRS.

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

Hi Anonymous ,

 

I am not sure if you went through the list of datasource that are supported by PBRS.

In your scenario you are using Sharepoint Online which is clearly not supported by PBRS, therefore your data refresh is not working.

 

Thanks,

Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Pragati11  Hi Pragati,

     

    though it is sharepoint source we can still get the excel file url and use it as a web connection in Power BI.

    I have seen that it works fine.

     

    Have you ever used such sources in PBIRS?

     

     

    • 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