Forum Discussion

Mornagli's avatar
Mornagli
Icon for Helper III rankHelper III
5 years ago
Solved

If I add custom column in Power Query that depend on specific column - each row the API get request?

I fetch my data with MPBI from Odata feed with an API call, the data is approximately 50,000 rows. After i get tha data, when im in Power Query - I try to add new custom column that relies on ex...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    yes, and yes.

Mornagli's avatar
Mornagli
Icon for Helper III rankHelper III
5 years ago

lbendlin Last question, My Data source does not have the Native Query eneblad, So
i created function to support folding that convert date to the MPBI format and it works,


Maybe when i click 'Expand' and then close and apply cause my server errors - the problem is that the Source not folding and then it fetch a lot of data that not necessary?

 

I saw more peoples in the forum that have the same errors and it seems that MPBI send to much HTTP request on each cell and that cause the problems.

I attached the link

 

Maybe there is a solution to those problems and i didnt found it.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

the link you posted matches my experience. I think that often the data source thinks it will only handle the occasional request (like a microservice) and it is not optimized for handling lots of requests or spooling large amounts of data. You will have to experiment with a compromise setting (for example fetch data in batches of 2000 records).