Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

SharePoint Online List dataset Credentials (Windows Account is Missing) so cannot schedule a refresh

Hello,

 

It seem that I cannot scedule a dataset refresh to get fresh data from a SharePoint Online list where the authentication method will not be anonymous. The reason seem to be the missing authentication option (Microsoft Account) for the dataset in the Power BI portal.

 

You may see print screns below (1) from Power BI desktop and (2) the Power BI dataset settings.

 

I made sure that I have the most up to date Power BI Desktop version when creating the report. Could it be that there is some seeting needed in the Power BI Admin console? Is it allowed to scedule dataset refresh for SharePoint Online lists when you do not use anonymous authentication method?

 

  • Power BI Desktop

  • Power BI portal (dataset setiings)

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    I created a support ticket and the resolver suggested to replave the HTTP part of the URL to HTTPS. This solved the issue and I can see the OAuth2 option now!

6 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Anonymous ,

     

    I have made a test, you can select OAuth2 authentication.

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      Hello,

      I do not get the OAuth2 option at all. Where do you see it? Power BI desktop? Dataset credential? Both?
      • v-yuta-msft's avatar
        v-yuta-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        Anonymous ,

         

        You can select "Oauth2" option in "dataset credentials" session. If you don't see the option, please check if there're other data sources in your report dataset.

         

        Community Support Team _ Jimmy Tao

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.