Hello all, I am new to the forum and new to Power Bi in general, so please bare with me and my understanding.
I have the below part of a query written:
startUrl = Json.Document(Web.Contents("https://WEBSITE.COM?page[first]=50")), Blanking out the website for obvious personal reasons. It has a query at the end of the url, calling the first 50 results that this specific API gets. While this code works perfectly the way it is, I am wanting to convert this for use in Bi Service.
I have tried using some thing like:
startUrl = Json.Document(Web.Contents("https://WEBSITE.COM",[Query=[page[first]=50]]))But it gives an error that "page" is an Invalid identifier. I am able to use query with other url queries fine, but I believe it does not like the brackets.
Any help with this issue would be grateful, and please pardon my lack of knowledge with Bi.
