Forum Discussion
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 existing column.
I want to know if every cell that I create in the new column - the MPBI send another API call to our server to get the data...
This proccess cause a lot of problems and i try to understand why is this happening.
And is there a way to make those changes in Power Query locally with the data that i allready fetch instead with the extra API call?
yes, and yes.
13 Replies
Yes. show a sanitized version of your M code.
Thanks lbendlin
What im doing is:
- Go to Transform Data
- Put my API URL and get the full Metadata- In specific table I - 'EXPAND' to specific sub-table
- Then i mark in the specific Table only the columns i needAnd after this, when i click 'Close&Apply' - The MPBI stuck and it make problems to the server of my API.
Also if i add columns it make problems...
I try to understand how can i make changes, add columns in my data in MPBI without call the API for each cell....
As i see it, when im in power query, After i load the data from the Odata feed, every change is locally but maybe i dont understand the proccess...
Since this is an ODATA feed - have you considered using ODATA filtering for your request?
