- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Hide secrets and keys - API - Power Query

There should be a secure way to pass secrets or keys when making an API call (e.g. web.contents) in Power Query M.
Suggestions:
A) Make it possible to enter and edit secrets in Power Query, similar to how we enter and edit data source credentials in Power Query. Make these secrets encrypted and redacted. The secrets should be available to use as variables in the M code. When entering a secret, we would give it a name, which we can reference as a variable in the M code. We would only see the name, but the value would not be visible (the value would be redacted).
B) Make an Azure Key Vault connector for Power Query, that will make it possible to fetch secrets from AKV and assign the secret to a variable in the M query. This variable can be passed as part of the header in an API call.
C) Make it possible to redact some variables in M, so that we can use secret variables without the value being visible in the Power Query user interface.
The main point is that we want a way to use secured and hidden secrets as part of API calls in Power Query.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
-
frithjof_v on: Hide secrets and keys - API - Power Query
- UlrikH on: Power BI - Org apps and cross-report drillthrough
-
pacifist
on: Power BI | Enable or Disable all datasets Refreshe...
- MarkB63 on: Page-Level security in reports
- Matt_Benham on: Increase pipeline max activities + fix lakehouse d...
- leyre on: Multi-window support for Power Bi Desktop
-
orbe
on: Add default values for date slicer with style "bet...
- JaydeHm on: Visual Suggestions
- Thomas_Pouliot on: Enhance Paginated Report Settings Flexibility - Pa...
- chadrenstrom on: Backup of data warehousing
- New 14,811
- Need Clarification 2
- Needs Votes 22,624
- Under Review 619
- Planned 251
- Completed 1,643
- Declined 220
-
Power BI
38,586 -
Fabric platform
520 -
Data Factory
439 -
Data Factory | Data Pipeline
271 -
Data Engineering
244 -
Data Warehouse
174 -
Data Factory | Dataflow
142 -
Real-Time Intelligence
126 -
Fabric platform | Workspaces
104 -
Fabric platform | OneLake
104 -
Fabric platform | Admin
98 -
Fabric platform | CICD
76 -
Real-Time Intelligence | Eventhouse and KQL
57 -
Fabric platform | Capacities
53 -
Real-Time Intelligence | Activator
50 -
Fabric platform | Security
42 -
Data Science
41 -
Fabric platform | Governance
39 -
Data Factory | Mirroring
36 -
Real-Time Intelligence | Eventstream
30 -
Fabric platform | Support
28 -
Fabric platform | Data hub
26 -
Databases | SQL Database
23 -
Databases
19 -
Data Factory | Apache Airflow Job
3 -
Product
2 -
Real-Time Hub
1