Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

Power Query Embed API Key from another Power BI Query into API Table

  • 1.  Power Query Embed API Key from another Power BI Query into API Table

    Bronze Contributor
    Posted 2 days ago
    I am importing data from an API, the API has a token that expires after a few hours, I am bringing in the Token into a separate Power BI Query, I need to figure out how to embed the API Token, into a different API table, so that upon refreshing the other API table, the new API key always gets applied to the table and lets me bring in the new data.  Currently I have to copy and paste the API Key into the other API table, to get it to refresh.  I would like to automate this process.  I have tried referencing the API key table in the M code, but without success.  Is there a way to use parameters for this?

    ------------------------------
    marek bujarski
    Consultant
    DeKalb
    ------------------------------