Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI Athena Incremental Refresh

Hi All   I have been successfully using Power BI’s incremental refresh daily with a MySQL data source. However, I can't get this configured with AWS Athena, because seemingly the latter interpret...
Need Help
bertcasier's avatar
bertcasier
New Member
5 years ago

From what I can find on the internet:

AWS athena does not support prepared statements, they advice to construct the full select before sending it to athena.

 

Is there a way to do that in powerQuery, in attempt to fix the incremental refresh?
We should be able to construct a query where RangeStart and RangeEnd are replaced before sending it to Athena

rafaelruivo's avatar
rafaelruivo
Regular Visitor
5 years ago

After much, much suffering, I was able to login back to this community. Not even that works well in PBI!

Well, to the subject at hand, I think I got it working. I added another step before the date filter, and it seems to have worked. I think it moves the filter for after the query load on PBI, and this is very, very annoying, but seems to be working.

Sometimes I don't understand why I still insist in punishing myself with Power BI.