Forum Discussion
If I add custom column in Power Query that depend on specific column - each row the API get request?
yes, and yes.
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.
lbendlin Thank you again.
So if im in transfoirm data -> enter my ODATA full metadata url and choose table -> in this table i 'EXPAND' another syb-table -> and choose from the table only specific columns that i need.
After all this proccess when i click 'Close&Apply' - the MPBI stuck for a long time and the DB server is cause problems.
Is that a problem that come from the performant of our DB API?
I try to find a way to make the fetching easier to the API, If i will load instead of the full metadata, only the specific tables that i need, will it help?
thank you.yes, and yes.
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.
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).