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,


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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        ushah763,

        You would need to change the credential option in Power BI Desktop, then re-publish PBIX file to Power BI Service.


        Regards,
        Lydia