Forum Discussion
Helper IIIIf I add custom column in Power Query that depend on specific column - each row the API get request?
yes, and yes.
Super UserYes. show a sanitized version of your M code.
Helper IIIThanks 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 need
And 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...
- lbendlin
Since this is an ODATA feed - have you considered using ODATA filtering for your request?
- Mornagli
Hi lbendlin ,
I need couple of tables from this source, so i put the url that give me all the tables, And from it i take the tables i want.
If i will fetch each table separately, it will make diffrence?With the filtering i will use for create 'Incremental refresh', but i need to understand why changes that i make in the Power Query after i have the table make problems when i try to 'Close&Apply'... And if there is an option to add columns and make changes in the Power Query' without call again to the API server for each cell.
- lbendlin
if you already know which tables and columns you need then you can avoid a lot of work. If however you don't have that prior knowledge then you have to use the long winded process.