Reply
mpataki32
Helper III
Helper III

Power Query for API call - keys

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?

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

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.

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

It is already available in Power Automate.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)