Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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
Hi @RachHE
Please refer to the document below.
https://ssbipolar.com/2018/11/23/power-bi-dataflows-reuse-without-premium/.
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.
| User | Count |
|---|---|
| 21 | |
| 13 | |
| 8 | |
| 6 | |
| 4 |
| User | Count |
|---|---|
| 49 | |
| 43 | |
| 36 | |
| 15 | |
| 15 |