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,

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

    • ushah763's avatar
      ushah763
      Helper I
      7 years ago

      Anonymous

       

      i do not have that option.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        ushah763,

        What connector do you use in Power BI Desktop to connect to the Excel file? It seems that you are connecting to Excel file which is stored in a network path.

        Regards,
        Lydia