Make GET request once but use results in multiple tables

[Kurren]

I have a sample pbix on my onedrive here: https://1drv.ms/u/s!Ath7XDDsi0FIo01YYv5dzHoJDpAi?e=9tVyga

I have a table "posts" which makes a GET request to here. I have 3 more tables "posts (2)", 3 and 4 which all use "posts" as the source table and do their own transformations. 

The problem here is that when I refresh and use fiddler, I can see that the GET request is being made 4 times. Is there any way I can make the GET request only once when refreshing? I am facing this problem in another report where the GET request is taking a while and calling it multiple times is causing issues.

Thanks

[ppm1]

Please see this video - (2) Inside Power Query reference queries for Power BI and Excel - YouTube

You can likely get down to a single call by unchecking parallel loading of tables (and maybe ignoring privacy check).

Pat

[Kurren]

Hi Pat

Disabling parallel load seems like a big sacrifice. Can power BI not parallel load the source tables and then pass that data into other tables?