Refresh Data Source Error in Power I Service when using function

Hi AVH_Tech 

Please test and ensure it works when invoking function "GetStData1" into "ST Data2" table.

If it doesn't work, maybe you need to change your queries.

Here are some references:

(pay attention to the queries of your function, privacy level setting,,ect)

https://www.myonlinetraininghub.com/scrape-data-multiple-web-pages-power-query

https://blog.crossjoin.co.uk/2016/10/01/using-the-invoke-custom-function-button-in-power-bi/

https://www.poweredsolutions.co/2019/03/12/data-privacy-and-the-formula-firewall/

Besides, i see there is a "expand columns" step in function "GetSTData1", why there is another "expand columns" step in "ST Data3" table? 

maybe you can delete this step in "GetSTData1".

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.