Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Community.
I have a woocommerce website and an Export module installed on the site.
the export module provides 3 links. The first triggers the report creation. The second returns the status...proccessing...complete and the 3rd that downloads the file (Excel).
I want to use Power Query to do the job. I.e. trigger, wait, when status is complete to download the file and bring it for transformation.
Can you help me on how to do that So Far I see only Get Data -> From Web but only allows one link to be inserted....
Thanks....it seems that I have to try the Invoke.After and see if I can implement it!
@mikalhsxxx wrote:Hello Community.
I have a woocommerce website and an Export module installed on the site.
the export module provides 3 links. The first triggers the report creation. The second returns the status...proccessing...complete and the 3rd that downloads the file (Excel).
I want to use Power Query to do the job. I.e. trigger, wait, when status is complete to download the file and bring it for transformation.
Can you help me on how to do that So Far I see only Get Data -> From Web but only allows one link to be inserted....
Hi @mikalhsxxx
Based on my knowledge for Power BI, i'm afraid these requirements are unable with Power BI.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @mikalhsxxx,
it won't be simple but I'm sure it is possible. You can't just click it all in the UI but you have to write your PowerQuery query which does the job for you. What you need is the following function: Invoke.After. You use this function for calling your web requests after a defined amount of time.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.