Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dataflow Timeout and "Query Contrains Errors"

Hey, I've set up a new gateway to access our data through an api / Gateway and want to set it up as a dataflow.  I'm using a query which works in powerbi desktop , it takes about 10-15 minutes to ...
dataflow
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

    Thanks for the response. I was over thinking it. 
    I used Relative path to get past the dynamic URL issue and used startAt and maxResults for each entity. ie rows from 0-2000 and then a second entity of 2001-4000 and so forth. 
    Combining these tables into 1 made there no need for pagination.

    Hope that helps someone that needs pagination in their dataflow. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

Thanks for the response. I was over thinking it. 
I used Relative path to get past the dynamic URL issue and used startAt and maxResults for each entity. ie rows from 0-2000 and then a second entity of 2001-4000 and so forth. 
Combining these tables into 1 made there no need for pagination.

Hope that helps someone that needs pagination in their dataflow. 

JoeRobert06's avatar
JoeRobert06
Icon for Helper II rankHelper II
5 years ago

This is a good post however what if pagination is required when you are dealing with many pages. Is there a work around this? I am doing something similiar by using a relative path with a dataflow but embedding a function in the query so that I can merge all the pages together. This works in desktop but I cann get this to execution as a dataflow. Each row value comes back as an [Error] instead of a [list]