Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Data Days Monthly is back. Join us on March 26th for two expert-led sessions on 1) Getting Started with Fabric IQ and 2) Mapping & Spacial Analytics in Fabric. Register now

Power BI (Azure-hosted SaaS service) to AWS S3 via Athena Connectivity

Hi Team,

 

We are trying to connect to AWS S3 Bucket via Athena from Power BI (Azure-hosted SaaS service). In a high level we have below requirements

 

  • We will pull the data from AWS and populate the Power BI Semantic Layer Cache and Power BI reports will use the cached data for reporting
  • The connection should use federated user identity which has username and password stored in cyber ark.
  • Connection should also suffice the data orchestration. Whan data is changed in AWS, API call in Power BI should trigger the data refresh

 

Do we have any jdbc driver which is provided by AWS or Microsoft for the same. I know that that ODBC driver is a possibility but i think there are some challenges with it.

 

Thanks,

Gaurav

 

Status: New