Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI Report Server - Sharepoint Datasource scheduled refresh

Hi,   We have a power BI dashboard that connects to a sharepoint document. I have used the Sharepoint Folder datasource to connect to this document. It works well on the power BI report server desk...
SharePoint
Web
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
7 years ago

What sort of Sharepoint instance is this? Is it Sharepoint Online or an on-premise Sharepoint? If it is on-premise you can use Windows auth and enter the account details of a windows user which has access to the document. Unfortunately if it's Sharepoint Online you'll find that it's not one of the sources that currently supports scheduled refresh (see https://docs.microsoft.com/en-us/power-bi/report-server/data-sources)

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi - Thanks for your reply. This is an on-premise Sharepoint and we tried Windows Auth and that did not seem to work.

     

     

    • d_gosbell's avatar
      d_gosbell
      Icon for Super User rankSuper User
      7 years ago

      What is the error you are getting? Is it just one about incorrect username/password?

       

      Have you tried entering the username in the form of <domain>\<username> ?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Sorry for the delay. It is showing up as incorrect username/password