SQL Injection: Preventing Sensitive Data Exposure in PowerApps - Masking Headers: x-ms-request-url

Like (0) Share

Report

Posted on 12 Nov 2024 09:59:07 by darkhorse12

I’m working on securing PowerApps connections to SQL databases but noticed sensitive information like x-ms-request-url could potentially be exposed, raising concerns about SQL injection risks. While PowerApps is known for its security, I believe there must be a way to prevent these headers from being exposed. Has anyone used Azure API Management (APIM) or Content Security Policy (CSP) for masking headers or preventing potential vulnerabilities? Any suggestions or best practices would be greatly appreciated!

Categories:

Authentication

Policy Templates

sqlInjection.png

All responses (1)

Answers (0)

Suggested answer

SaiRT14 1,966 Super User 2025 Season 1 on 27 Nov 2024 at 17:17:27

Like (0)

Report

SQL Injection: Preventing Sensitive Data Exposure in PowerApps - Masking Headers: x-ms-request-url

Here are the best practices:

APIM acts as a gateway between your PowerApps and SQL databases, enabling you to control, mask, or block sensitive headers.

Ensure that SQL queries in PowerApps, especially in custom connectors or flows, use parameterized queries:

Instead of storing connection credentials, use Azure Managed Identity to authenticate PowerApps with SQL databases.

Ensure SQL endpoints are only accessible from trusted IP ranges or services like APIM.