With DynamoDB Streams and the data-transformation feature of Amazon Kinesis Firehose, you have a powerful and scalable way to replicate data from DynamoDB into data sources such as S3 and then analyse using Power BI
Create lambda function to buffer items newly added to the DynamoDB table and then send a batch of these items (JSON-formatted source records) to Amazon Kinesis Firehose delivery stream
This lambda function takes all messages in the DynamoDB stream and forwards them to the Firehose delivery stream.
Crawlers can crawl both file-based and table-based data stores. Crawlers can crawl the following data stores – Amazon Simple Storage Service (Amazon S3) & Amazon DynamoDB
You can also enable or disable a stream on an existing table, or change the settings of a stream. DynamoDB Streams operates asynchronously, so there is no performance impact on a table if you enable a stream.