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
Solved! Go to 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.
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.
User | Count |
---|---|
10 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
16 | |
8 | |
7 | |
4 | |
4 |