Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Cosmos Db

Hi,

I need help for Cosmos Db . Is their neccessary to create Datawarehouse for Reports(in power BI) using Cosmos Db and How to analysis the data  in Power BI with unstructured to structured?

 

Thanks in Advance

Reports

2 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    6 years ago

    Hi Anonymous, 

     

    In order to get data from Azure Cosmos DB data in Power BI, you need to create a Azure Cosmos DB account and import file eg: JSON to your Azure Cosmos DB. Then you can use Azure Cosmos DB connector in Power BI desktop to transform data. For more information, I would suggest you go through this document: https://docs.microsoft.com/en-us/azure/cosmos-db/powerbi-visualize

     

    Best Regards,
    Qiuyun Yu

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Qiuyun Yu,

       

      Thank you for your response. I need help for data cleaning process example data come from Json file but their is some data may be null and some column may be blank how to clean unnecessary data in Power BI? and other option to create Datawarehoue for cleaning data? 

       

      Thanks In advance