Forum Discussion

ushah763's avatar
ushah763
Helper I
7 years ago

Scheduled refresh has been disabled.

I had created a report which is pulling data from two sources. (1) an excel file in sharepoint and (2) the opportunity object in Salesforce.com. I am logging into the latter with my credentials.   ...
Need Help
ushah763's avatar
ushah763
Helper I
7 years ago

Anonymous i am connecting to sharepoint online O365. I had to install a personal gateway for the scheduled refresh to work.

Now everytime my computer is asleep or down, the refresh fails.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

ushah763,


What authentication method do you use for SharePoint data source? When you connect to SharePoint online data source, gateway is not required to refresh the dataset. Does your dataset contain other on-premises data sources?

Regards,
Lydia

  • ushah763's avatar
    ushah763
    Helper I
    7 years ago

    Anonymous using windows authentication. 

     

    i do not see an option to change it to anything else.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      ushah763,

      If you connect to SharePoint online data source, you would need to use Organizational account instead of Windows authentication in Power BI Desktop, and you would need to use OAuth2 method in Power BI Service.

      Regards,
      Lydia

      • ushah763's avatar
        ushah763
        Helper I
        7 years ago

        Anonymous

         

        I do not see that option when looking at the data source connections from the service.

        How, where do I access that to change it? on the desktop or service? and where?

         

        When I go to File > Options and Settings > Data Source Settings

        in Power BI Desktop, this is all i see when i select "global permissions"

         

         

        So where do I go to change the data source credentials?