PowerBI report connecting to AWS Athena fails

[Carina1111]

Hi everybody!

I'm currently trying to connect a PowerBI Report to our AWS Athena datasource. 
This works perfectly fine for PowerBI Desktop using the official connector from AWS
(https://docs.aws.amazon.com/athena/latest/ug/connect-with-odbc-and-power-bi.html)

As soon as I'm uploading the report to the Report Server I get errors as such:

"The given data source kind is not supported. Data source kind: UnknownFunction"

Now my question, does the PowerBI Report Server support the connector to AWS Athena?

If yes ... any ideas if I need some additional configuration on the Report Server? (i've configure the odbc drivers and firewall settings already)

If no ... any ideas on how to overcome this? Is there a plan that the connector will be supported?

Thanks in advance!

Carina

[d_gosbell · Accepted solution]

Unfortunately for you I cannot see Athena on the list of data sources supported by Report Server Power BI report data sources in Power BI Report Server - Power BI | Microsoft Docs 

Since your data is already on another cloud service in AWS have you considered putting your report onto the Power BI service instead of using the on-prem Report Server. The on-prem Report Server primarily has support for on-prem data sources while the cloud service has support for both cloud data sources and it can access on-prem data through a data gateway.