Forum Discussion

maneesha's avatar
maneesha
Frequent Visitor
4 years ago

Fields missing - Azure Cosmos DB

I recently connected Power BI to Azure Cosmos DB table and wanted to build a dashboard out of the data.

 

It had several columns, and expandable columns. But some of the fields I was looking for was missing.

 

Any idea why this happens and any workaround to get all the fields?

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi maneesha,

    Did you mean the data connector can't get the custom fields/properties that add on the data source side? AFAIK, power bi data connectors have pre-defined the responded table structure and they will get the common data table fields. 

    If you want to get all the general and custom fields, please use a web connector with the rest API instead.

    Solved: Pull data from a REST API Authentication - Microsoft Power BI Community

    Regarsd,

    Xiaoxin Sheng

  • Learner_SG's avatar
    Learner_SG
    Helper IV
    4 years ago

    Hi Maneesha, Were you able to solve your problem? If so, could you explain. I am also in a similar situation.

    Thanks.

  • RichHead1821's avatar
    RichHead1821
    Resolver I
    4 years ago

    I experience the same issue, if the list I am looking to expand has no data in the sample rows pulled back when building the query, you don't get the option to expand. I've yet to find a solution for this 😞