Forum Discussion
If I add custom column in Power Query that depend on specific column - each row the API get request?
yes, and yes.
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.
Thank you for your replays lbendlin .
I know which tables i need, but maybe in the future i will need more.
More importent for me is to know if after i choose specific table and load it to the Power Query, the changes that i want to do can be only loccally and not to active tha API GET request for each change.
That's a decision you have to make for yourself - depending on size and source performance . Try one way and if it's not satisfactory then go the other route.
Also: You need to distinguish between the effect this has on you as the developer/dataset refresher and the effect it has on your report consumers. If you have to wait longer but they have a good experience then I would call that acceptable, definitely better than the other way round.
lbendlin Sorry for the misunderstanding, But the effect that i want to prevent is to send for each cell that i add in a new column an API request to the Odata feed server - this is my main goal, So is there a way to add column that use existing column data, Without use my data source?
Why after i load the table to the Power Query, When i make changes, the MPBI does not use the data on the power query?
Thank you.yes, you can reference any prior step in your Power Query. What you cannot avoid is the effort to pull the data from the source. Somehow you have to pull that, and it doesn't matter much* if you pull it all in one call or in separate calls.
* It all depends on how performant your data source is.