Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi there,
I have an API that I want to paginate in a Power BI Dataflow. I tried this code in the desktop (dataset) and it refreshes fine. It also shows data in the dataflow but when I close the dataflow I get the error message: One or more table references a dynamic Data Source. Not able to save Dataflow.
So I have the followings queries/functions/parameters in the dataflow:
1 parameter where I provide my BaseURL (https://www.cannotshow.nl)
1 parameter where I provide my Bearer token (Bearer abcdefgheijklmnop)
1 Function called TEST:
Solved! Go to Solution.
Put the query pairs into the Query section, not the Relative path section.
Thanks, that did the trick.
Solved it like this:
You specified the query as part of the RelativePath. Try specifying it separately as the documentation suggests.
Hi Ibendlin,
Thanks for your reply, I thought I did what the documentation suggests. What do you mean I specified the query as part of the RelativePath, and how do you suggest to change it?
Put the query pairs into the Query section, not the Relative path section.
Thanks, that did the trick.
Solved it like this: