Forum Discussion

RicardoAGdSilva's avatar
RicardoAGdSilva
Frequent Visitor
2 years ago

Contentstack API - dynamic data sources aren't refreshed in the Power BI service

Good afternoon all,   I have been facing this issue for a few days, already check the forum and Chris Webb blogs and all the solutions provided didn't work. Soory for the post on this topic again b...
Need Help
Tips and Tricks
RicardoAGdSilva's avatar
RicardoAGdSilva
Frequent Visitor
2 years ago

When write the query like this I have the same issue and doesn't work: 

 

let
Source = Json.Document(Web.Contents("https://eu-cdn.contentstack.com",
[RelativePath="/v3/content_types/TYPE_OF_CONTENT/entries",
Query[XXXXXXX="ABC",include_count="true"],

 

But if I write the query with only one parameter it works: 

 

let
Source = Json.Document(Web.Contents("https://eu-cdn.contentstack.com",
[RelativePath="/v3/content_types/TYPE_OF_CONTENT/entries",
Query=[XXXXXXX="ABC"],

 

 

When way I can keep the query with two parameters?

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    check if your "true"  parameter value is case sensitive.

    • RicardoAGdSilva's avatar
      RicardoAGdSilva
      Frequent Visitor
      2 years ago

      I checked and if I change it, it gives an error.

       

      This API as a limit of 100 per page but the link doesn't have the page number. I have been looking for other ways to go around this but can't find anything.

       

      So my problem it's that if I Query=[XXXXXXX="ABC"], I get 100 data points, but I want all the others. If I  query this I can publish and PBI Service refresh without issues.

       

      But we are using Query[XXXXXXX="ABC",include_count="true"], to get all the other pages together, but if I use this one PBI Service won't refresh the data.

       

      Don't know if someone as a better aproach to this situation.