Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Need help in changing my Azure Data lake connection string dynamically with API call

Hi All,   I have a requirement to change the connection string to the Azure DataLake Gen 2 dynamically based on the tenant id. My data source is Azure Data Lake Gen2.   We are maintaining a stor...
Data Protection
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Amit,

    The reference which u have provided is not suitable to my requirement, because it is showing me a procedure to set the parameter in Power BI desktop in Power Query and later on provide the tenant id in the parameters section of Power bi service and refresh the report. My requirement is completely different here. No manual provision of parameter should exist. Based on the user login info in Azure, it has to capture the tenant id and provide it to the tenant id parameter.

     

    Thanks

    Lakshmi Koduri 

     

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      6 years ago

      ImkeF , can you help on this.

      • ImkeF's avatar
        ImkeF
        Icon for Community Champion rankCommunity Champion
        6 years ago

        Hi Anonymous ,

        unfortunately I'm not aware of any API that returns tenant IDs.
        The Graph API could return the userprincipalname of the currently logged in user (you need a custom connector for it: https://www.thebiccountant.com/2019/04/17/graph-api-custom-connector-power-bi/)
        Not sure if you have any "translation" table that could lookup the tenant ID on that basis?