Forum Discussion

cnegroni's avatar
cnegroni
Regular Visitor
6 years ago
Solved

How to enter Azure AD credentials to set a Schedule Refresh for a report in PBI portal

Environment: Azure SQL DB with and AD account (type_desc External_User) with db_datareader access on the DB. A PBI report was created using this DB and I need to set up the Schedule Refresh of the PB...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI cnegroni,

    You can choose 'OAuth' authorization mode to use your ms account credentials to verify this datasource.

    User Authentication with OAuth 2.0 

    Regards,

    Xiaoxin Sheng

venal's avatar
venal
Icon for Memorable Member rankMemorable Member
6 years ago

cnegroni 

Please refer the below path and snippet.

 

Path:- Power BI Service >> Select the workspace (Ex:- Sample) >> Datasets >> select the dataset (EX:- CRDThrough-B) >> Settings

 

 

Check for the Datasource Settings and evaluate with the right credentials. (Authentication - Microsoft Account,Privacy Level - Organizational).

 

Schedule Refresh >> enable "keep your data upto date" and select the frequency and check for the refresh.

 

If you have any concerns, please let us know.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

 

BR

venal.

  • cnegroni's avatar
    cnegroni
    Regular Visitor
    6 years ago

    Thanks for your answer Venal but in the Authentication Method the only options available are Basic, Windows, OAuth2 (there is no Microsoft Account option).

     

    Thanks

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      HI cnegroni,

      You can choose 'OAuth' authorization mode to use your ms account credentials to verify this datasource.

      User Authentication with OAuth 2.0 

      Regards,

      Xiaoxin Sheng