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 PBI report using the AD credentials but I do not know how to do that in PBI portal (I have a PBI Pro account to access the PBI portal).

 

Thanks for your time.

Need Help

3 Replies

  • 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