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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mansivora
Frequent Visitor

Enterprise Gateway & Auto refresh with Amazon Athena-ODBC Connection

Hi,

 

We are exploring an option to connect to Amazon Athena using Power BI to build some reprots. Seems like we can do that in Power bi using ODBC conenction. Few questions:

  1. Is it possible to publish the report and set up auto refreshes?
  2. Are there any challenges setting up Enterprise Gateway for ODBC connections (to Athena)?
  3. Any overall challenges for report, filters, I should be aware of?

 

Would appreciate more insights.

 

Thanks

Mansi

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @mansivora,

 

AFAIK, current power bi odbc connector not support auto refresh. You can consider to use gateway to setup schedule refresh for that datasource.


Maybe you can take a look at following sample project to create a custom connector to achieve direct query mode for odbc datasource:

DirectQuery For SQL ODBC

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @mansivora,

 

AFAIK, current power bi odbc connector not support auto refresh. You can consider to use gateway to setup schedule refresh for that datasource.


Maybe you can take a look at following sample project to create a custom connector to achieve direct query mode for odbc datasource:

DirectQuery For SQL ODBC

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi Xiaoxin,

I am wanting to achieve schedueld refreshes with an ODBC connector without relying on a gateway. Is this possible yet in Power BI?

 

Many thanks,

 

Tom

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors