Forum Discussion

gvrspk17's avatar
gvrspk17
Regular Visitor
2 years ago

PowerBI DataRefresh should be handled with Generic / Common ID

Hi All, 

i have a requirement to handle PowerBI Report Refresh using CommonID because no of reports are high and also i dont want to refresh everytime / edit credentials when ever password change. 

 

CommonID password used to change every 2months once , so my ask is, 

 

how to store CommonID username , Password in Azure AD and to use CommonID in PowerBI dataset refresh. 

so if the password changes , i have to change in one place (AD / Keyvalut) and that should automatically pickit up in power bi and should not show failure or i dont want to goto each report to refresh / edit credentials. 

 

please share detailed steps to store commonid and how to use in powerbi dataset refresh. 

 

If i use Generic id also, i am keep on Refreshing and edit the credentials in each report. I May missed proper steps, please share detailed steps to achieve this task. 

 

Thanks in advance. 

Need Help
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, gvrspk17 

    What you can try is to use Azure Key Vault. And you need to understand the limitations of Azure Key Vault in Power BI, as shown in the following image:

    Basic knowledge of Azure Key Vault. For more information, see: What is Azure Key Vault? | Microsoft Learn

    For more information about configuring Azure Key Vault, you can check out the following documentation:

    Bring your own encryption keys for Power BI - Power BI | Microsoft Learn

    The above is a possible way to set it up with a good understanding of both products.

     

    Best Regards

    Jianpeng Li

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