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.
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:
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.