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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Unable to create data source

Hi,

 

I am trying to display report in Power BI service from Athena data source. I can successfully connect data source from my PowerBI desktop. The problem is when I published to Power BI service, I cannot connect to the data source and cannot open the report that I have created in Power BI desktop. When adding data source (in Power BI service), there are only 2 authentication options: Anonymous and OAuth2. It's giving me the error whichever option I chose. With OAuth2, it only leads me to Azure AD sign in page.

 

mOn2t_2-1652435892053.png

 

 

mOn2t_1-1652435771506.png

 

 

 
 
 
 

Note: I have authenticated ODBC driver using IAM credentials (i.e. using access key & secret access key). In On-premises data gateway, I have signed in using Azure AD account as the sign in leads me to this page.

 

Could anyone advise/point out where I am doing it wrong?

 

 

1 REPLY 1
Tutu_in_YYC
Super User
Super User

Power BI Gateway is having an issue currently, it could be related to your issue. Microsoft is aware of this.

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Kudoed Authors