How to connect Power BI to DynamoDB

[vibhoryadav23]

Hi, how can I connect DynamoDB to Power BI. I see some third party connectors as a solutions but is it possible to do it with the these 3rd party APIs? Has anyone tried that already?

Also, what is the pricing of these connectors?

Thanks in advance!

[v-chenwuz-msft]

Hi @vibhoryadav23 ,

You use Web.Contents() to connect DynamoDB via amazon dynamodb api to get data.

DynamoDB Low-Level API - Amazon DynamoDB

Web.Contents - PowerQuery M | Microsoft Docs

Welcome - Amazon DynamoDB

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[robertopolotecn]

Can you explain a little better how you managed to connect? Right now, I need to connect to DynamoDB, and this is the only thing I have found on the internet that sheds some light on it.

[amitchandak]

@vibhoryadav23 , ODBC driver way

https://medium.com/@nadakkannu.smart/how-to-create-a-table-from-aws-dynamodb-load-the-data-to-power-...

https://blog.panoply.io/how-to-analyze-dynamodb-data-in-power-bi

[vibhoryadav23]

Doesn't work.