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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

ushah763,

Do you connect to SharePoint online excel or on-premises sharepoint excel? What authentication method do you use in Power BI Desktop for the Excel file? Are you able to re-enter credential for the dataset1 in Power BI Service?

Regards,
Lydia

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