- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It is already available in Power Automate.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
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.
User | Count |
---|---|
17 | |
15 | |
13 | |
9 | |
8 |