Power BI ONLINE data pipeline to Azure Cosmos DB

[beapamittan]

Is there a way to connect the database I have on Azure Cosmos DB to Power BI Online? I am unfortunately running on macOS and can only use PowerBI Online which doesn't have the "Get Data" button to easily link them together. I also don't have a Microsoft Fabric subscription yet. Is it possible to create a data pipeline from Power BI Online to Azure Cosmos DB? Could be through Data Factory if needed. If yes, could you kindly run me through the steps. Thank you. 

I saw this but I think it's for the desktop app and was wondering if it would be the exact same. If anyone has any experience, please let me know. Thanks so much. 

[Anonymous · Accepted solution]

Hi @beapamittan ,
As I understand it, you want to link Azure Cosmos by creating a power bi pipeline, which is a couple of ways you can look at it.
You can use Azure Data Factory (ADF) to create a data pipeline that moves data from Azure Cosmos DB to a storage solution like Azure Blob Storage or Azure Data Lake. Once the data is in Azure Blob Storage or Azure Data Lake, you can then use Power BI Online to connect to that storage and access the data.
If you don't use the power bi pipeline, you can also provide an integrated Power BI experience in the Azure Cosmos DB portal for Synapse Link-enabled accounts
Here's some documentation you can refer to
Power BI and serverless SQL pool to analyze Azure Cosmos DB data with Synapse Link | Microsoft Learn
Integrated Power BI experience in Azure Cosmos DB portal for Synapse Link enabled accounts | Microso...
Power BI tutorial for Azure Cosmos DB | Microsoft Learn

Best regards,

Albert He

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