Forum Discussion

PBILover's avatar
PBILover
Icon for Helper V rankHelper V
6 years ago
Solved

Query folding with cosmos db on date field

Hi , Thanks all the users for always helping!!          I have a cosmos db as a source (JSON format), does power BI supports query folding?  I am trying to do Query folding on a date time (for the...
Need Help
PBILover's avatar
PBILover
Icon for Helper V rankHelper V
6 years ago

v-yingjl  thank you very much for your reply.

For your suggestion 'If you cannot use query folding of this data source in json format, try to use the data source connector' , can you please let me know which data source connector shall i use?

 

Sajjad's avatar
Sajjad
Frequent Visitor
5 years ago

Hi PBILover ,

Were you able to achieve this? and improve dataset refresh time after implementing incremntal refresh.

 

Thanks,

Sajjad

  • PBILover's avatar
    PBILover
    Icon for Helper V rankHelper V
    5 years ago

    Yes.. It works

    • Sajjad's avatar
      Sajjad
      Frequent Visitor
      5 years ago

      Hi PBILover ,
      Could you please shed more light into this ?

      - How did you enable query folding for cosmos DB - as from MS documentation folding is supported for only relational DB's and Odata, and not for No SQL DB (cosmos DB).

      - I have used Microsoft certified cosmos DB connector but unable to achieve query folding and reduce refresh time after implementing Incremental refresh. Which connector did you use?

      - Any other important steps that are required to follow.

       

      Thanks for your time.

       

      Sajjad

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        I'm also trying to understand if query folding and therefore incremental refresh is possible usng Cosmos db as the data source.

         

        I wonder if PBILover was referring to this connector, which expicitly states that it does deliver query folding...

         

        Nick