Forum Discussion
Solved
Help with syntax -'One or more table references a dynamic Data Source. Not able to save dataflow'
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 dat...
Put the query pairs into the Query section, not the Relative path section.
Thanks, that did the trick.
Solved it like this:(Page as number) as table=>letSource =Json.Document([RelativePath = "/test.test/rest/all/V1/orders",Query = [#"searchCriteria[pageSize]" = Text.From(10),#"searchCriteria[currentPage]" = Number.ToText(Page)],Headers=[#"Authorization" = "Bearer abcdefgheijklmnop"]])
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:(Page as number) as table=>letSource =Json.Document([RelativePath = "/test.test/rest/all/V1/orders",Query = [#"searchCriteria[pageSize]" = Text.From(10),#"searchCriteria[currentPage]" = Number.ToText(Page)],Headers=[#"Authorization" = "Bearer abcdefgheijklmnop"]])