Load large data from Cosmos DB into Power BI

[Anonymous]

I have a dataset of around 300 million and growing data in Azure Cosmos DB. When I load the data, it stops loading because of connection issues after loading few million rows. Then, I loaded top 50k rows and thought I can load the rest of data using Power BI service after publishing the dataset. Can we do it? or any other alternative to load the whole data? Please note that this is a graph database

@largedata cosmos db c# and power bi live data 

[Anonymous]

Thanks. I tried all of these. Nothing worked.

I have a Pro license and I tried using dataflow - Refresh is failing everytime.

[amitchandak]

@Anonymous , refer if this can help

https://www.phdata.io/blog/loading-large-datasets-power-bi-using-parameters/

https://towardsdatascience.com/change-your-approach-with-large-datasets-in-power-bi-ca488a5b1066

https://www.phdata.io/blog/power-bis-sum-vs-sumx-whats-the-difference-really/