Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I'm trying to do an API call that should send the following Call :
https://<<BASE-URL>>/rest/insight/1.0/iql/objects?objectSchemaId=3&iql=objectId=3
As documented here: Solved: Insight Rest API to query custom attributes (atlassian.com)
I currently have the following :
let
FetchPage = (url as text, pageSize as number, skipRows as number) as table =>
let
contents = Web.Contents(URL&"/rest/insight/1.0/iql/",[
RelativePath = "objects" ,
Query = [
objectSchemaId = "3" ,
iql = objectId = "7249" ,
maxResults= Text.From(pageSize),
startAt = Text.From(skipRows)]]),
json = Json.Document(contents),
Value = json[issues],
table = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
table meta [skipRows = skipRows + pageSize, total = 500]
in
FetchPage
The main issue I think is the fact that the line "iql = objectId = "7249" has a double "=".
Any Idea how I should fix my Call ?
Robbe
Hi @Robbe ,
how did you write it?:
so: "iql=[objectId=7249]"
or so: "iql=[objectId=""7249""]"
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi,
As soon as I put the "=" between quotations it switches the "=" to "%5B"
The other suggestions you gave :
Resulted still into this:
Are you sure the nested Queries work ?
Robbe
@ImkeF ,
Also when trying to add it hardcoded, it auto converts the "=".
how do I get this trough ?
Robbe
Hi @ImkeF ,
Thank you for your reply!
I indeed tried that aswell, but I got the following error :
let
FetchPage = (url as text, pageSize as number, skipRows as number) as table =>
let
contents = Web.Contents(URL&"/rest/insight/1.0/iql/",[
RelativePath = "objects" ,
Query = [
objectSchemaId = "3" ,
iql = [objectId = "7249"],
maxResults= Text.From(pageSize),
startAt = Text.From(skipRows)]]),
json = Json.Document(contents),
Value = json[issues],
table = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
table meta [skipRows = skipRows + pageSize, total = 500]
in
FetchPage
Any ideas?
Robbe
Hi @Robbe ,
if a nested record is required here, you could try the following:
iql = [objectId = "7249"] ,
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Check out the July 2025 Power BI update to learn about new features.