Can't save dataflow - dynamic data source

[RachHE]

Hi 

I've built a function in desktop that I would prefer to migrate to a dataflow, but although it works in desktop it won't save as a dataflow on the service.  The function uses UK Companies House APIs to get basic company data after passing it a company registration number (with the company being dynamic as a separate query loops through a table of companies and calls this function).

The error message and the relevant function M code are shown below:

From what I can find online it may be something to do with it being a dynamic URL (and I have a separate fuction which is dynamic and causes no problems). I tried experimented with using different combinations of RelativePath and a Query parameter but didn't have any luck. 

Any ideas?

Thank you 

[Anonymous]

Hi @RachHE 

Please refer to the document below.

https://ssbipolar.com/2018/11/23/power-bi-dataflows-reuse-without-premium/.

https://community.powerbi.com/t5/Developer/can-t-save-dataflow-one-or-more-entities-references-a-dyn...

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.