Power Query for API call - keys

[mpataki32]

We built a Power Query command in order to retrieve files from DropBox, the Power Query will be used for Power BI and MS Excel as well, my only concern is that in the command we need to pass keys in order to make a succesfull API call, what is the best practice in order to pass the keys for the command? 

I would not use parameters, since it can be read by end-users and would avoid hard-coding as well. What can be the solution for this?

[lbendlin · Accepted solution]

While we are waiting for Azure KeyVault support you can place your credentials on a sharepoint (in a text file in a secured folder)  and then treat that file as a data source during the Power Query ETL.

[mpataki32]

Hi @lbendlin, 

First of all thank you, is it something (KeyVault support) which has been announced by Microsoft? They are planning to have it?

What's new and planned for Power BI in Microsoft Fabric - Microsoft Fabric | Microsoft Learn

[lbendlin]

It is already available in Power Automate.