integration Apps with AWS hosted Apps & API with Power platform

(1) Share

Report

Posted on by CU20050114-0

we are leveraging some AWS environmental services like APIs in EC2 , DB -My Sql in AWS , those we need to connect for dashboard kind of Application in MS Power BI & power pages ...based apps -like dashboard-Power BI or Power pages

please share the resolution best practices to follow ups for it.

best regards- RB

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Jon Unzueta 1,827 Super User 2025 Season 2 on at

Like (0)

Report
@CU20050114-0

To connect AWS-hosted services (like APIs on EC2 and MySQL databases) with Microsoft Power BI and Power Pages for dashboard-style applications, here are the best practices and resolution steps you should follow:

1. Connecting AWS APIs (EC2) to Power BI / Power Pages

Power BI

Use Power Query (Web connector):

If your API is RESTful and returns JSON/XML, use the Web connector in Power BI Desktop.

Example:

https://your-ec2-api-endpoint.amazonaws.com/data

Add authentication headers (e.g., API key, bearer token) via Advanced settings.

Best Practices:

Secure your API with HTTPS and authentication (OAuth2, API Key, etc.).

Implement pagination and filtering in your API to reduce data load.

Use gateways if your API is not publicly accessible.

🔹 Power Pages

Use Power Automate flows or custom JavaScript to call your API.

You can also use Dataverse Custom Connectors to abstract API logic.

Ensure CORS is configured correctly on your EC2-hosted API.

✅ 2. Connecting AWS MySQL to Power BI / Power Pages

🔹 Power BI

Use the MySQL connector in Power BI Desktop:

Provide the hostname, port, database name, and credentials.

If the DB is not public, use a data gateway to connect securely.

Best Practices:

Use read-only users for reporting.

Optimize queries with views or stored procedures.

Consider incremental refresh for large datasets.

🔹 Power Pages

Power Pages connects best with Dataverse. To use MySQL:

Create a Power Automate flow that connects to MySQL and writes to Dataverse.

Or use Azure Functions or Custom APIs as a bridge between MySQL and Power Pages.

✅ 3. Security & Integration Best Practices

Authentication:

Use OAuth2, API keys, or AWS IAM roles for secure access.

Avoid hardcoding credentials—use Azure Key Vault or environment variables.

Network Security:

Use VPC peering, VPN, or PrivateLink if your AWS services are private.

Use Azure On-Premises Data Gateway for secure data transfer.

Performance:

Cache frequent queries.

Use pagination and filtering in APIs.

Schedule refreshes during off-peak hours.

✅ 4. Monitoring & Maintenance

Monitor API usage and DB performance using CloudWatch (AWS) and Power BI Service metrics.

Set up alerts for failures or slow responses.

Regularly update credentials and rotate keys.

🏷️ Tag me if you have any further questions or if the issue persists.

✅ Click "Accept as Solution" if my post helped resolve your issue—it helps others facing similar problems.

❤️ Give it a Like if you found the approach useful in any way.

Was this reply helpful? Yes No