Reputation: 273
Does PowerBI have a feature that is able to send a GET request to the AWS API Gateway? The Gateway is connected to a Lambda function that queries a AWS MySQL RDS table and send it back to PowerBI.
I don't want to directly connect PowerBI to my AWS MySQL RDS and set it as Public.
Upvotes: 0
Views: 965
Reputation: 4313
Yes, it can.
When you select Other, there is the option web. Here you can give the url and related data.
Now when having the report online you can set the automated update to once a day and it will also call the API.
Upvotes: 1