How to connect Cosmos DB to a Power BI datamart ?

[Balakrishna3690]

Hello , I am trying to use datamart solution to load my data from a COSMOS DB which is on Azure. How can do the ETL ? Do we have a connector that I can use to do the ETL and load the data ? 

[v-jtian-msft · Accepted solution]

Hi,@Balakrishna3690 
I am glad to help you.

The ETL in Power BI is   Extract, Transform, Load.
Currently Power BI has a connector for the Azure Cosmos DB
If you are trying to link in datamart with Azure Cosmos DB as the data source, you can try searching for Azure Cosmos DB, directly in datamart.

If I understand correctly, you can refer to my test below:

The test datamart >Get data

search for"Azure Cosmos DB"

Connect the data:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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