Forum Discussion
Helper IIIFetch Data from ODATA feed with an API call - Why each cell get an API call ?
Helper IIIHi Anonymous , the proccess i make is:
- With MPBI connector to ODATA feed, i insert the msin url of our API, And i get all the tables in Power Query.
- Then i have in specific table - sub table that i want to expand.
- If i expand this sub table, it takes some time but it work, but....
- When i click 'close&apply'- our server is having problems and the data not load...
i want to understand why it is look that for each cell, the MPBI send API call, Why after i insert the URL and get my tables in Power Query, The MPBI not use the values loccaly, it seems that MPBI send a lot of API calls....
In bottom line, Can i make only two API calls:
The first with the URL and then i load the tables that i want to Power Query.
And the second API call, When i Expand.
API server cant handle with 50,000 calls in couple of seconds....
I add my code that i changed manually the data, maybe it will clear some things:
Thank you.
HI Mornagli,
>>The first with the URL and then i load the tables that i want to Power Query.
Unfortunately, I don't think you can do custom on these parts. These operations are processed by power query engine itself and it hasn't provided the options to optimization them.
For this scenario, I'd like to suggest you do these operations(put data and expand table) out of power bi and only use power bi to get data from the result data tables.
As you know, power bi is a reporting tool, so it may not be good in each situation. In my opinion, use suitable tools to handle correspond operations should simply than force achieved by other tools.
Regards,
Xiaoxin Sheng