Forum Discussion
Dataflow doesn't get refreshed through Amazon Athena Power BI connector
Hello,
I'm trying to create a dataflow based on the data from Amazon Athena. I could see the data in the preview while creating the dataflow and save it without having an error. However, the refresh of this dataflow fails.
The error message is this: Error: Expression.Error: The import AmazonAthena.Databases matches no exports. Did you miss a module reference? ...
And this is the very first two lines in the Power Query of the dataflow:
let
Source = AmazonAthena.Databases("xxxxx (DSN name)", null),
Hence, it seems that the error suggests that PBI service somehow doesn't recognize the function AmazonAthena.Databases...
I'd appreciate any tip to solve this error/issue!
------------------------------------------------------------------------------------------------
To give you the further detaied background, let me use the image below. (The image source: https://aws.amazon.com/blogs/big-data/creating-dashboards-quickly-on-microsoft-power-bi-using-amazon-athena/ )
What worked:
- To fetch data from Athena to PBI Desktop on my laptop using Amazon Athena Power BI connector (after configuring the Amazon Athena ODBC driver on my laptop)
- To create a dataflow on PBI service using Amazon Athena Power BI connector (after configuring the Amazon Athena ODBC driver on our PBI gateway)
What is not working:
- To refresh the dataflow
2 Replies
- lbendlin
Super User
after configuring the Amazon Athena ODBC driver on our PBI gateway)make sure the same driver is successfully installed on all gateway cluster members
In the 64bit ODBC sources control panel verify that each of the cluster members has a definition for that dsn, and that a connection test is successful.
