OData timeout settings?

Mike Pearson
Mike Pearson Contributor
in General

Hi,

We've got a dataset we're trying to pull into Power BI via OData connection - with no luck.

It has around ~3.5mil records and the same dashboard successfully pulls smaller sets (and pulled this before a latest batch was added), but after a long time, we get the below:

image.png

Is there any configuration on the Aperture installation side we may have overlooked that could be timing this out, or has anyone overcome this issue in the past?

Thanks

Mike

Best Answer

  • Henry Simms
    Henry Simms Administrator
    Answer ✓

    I suspect there's some network timeout because the volume of data is large and coming from a single request.

    Data Studio supports standard OData $count, $top and $skip parameters to allow clients like powerBI to paginate results.

    I'm not a powerBI expert but there should be several ways to implement a loop in your query to fetch the dataset in chunks.

Answers

  • Mike Pearson
    Mike Pearson Contributor

    FYI - It seems like it may have been a Power BI Desktop limitation in this case, as ran out of resources locally.

Categories