Insight and Power BI

[Phill Purnell]

Hi,

We are building a POC for Insight cloud to show if the system can manage users, hardware and software assets and accounts and licences. 

One thing we do need is to report on the data we are inputting, we have been advised to do this via API and that we may then be able to link to Power BI, has anyone thought about this or tried it or any other way of reporting?

Thanks,

[Robert Wen_Cprime_]

If you need to connect your Insight cloud information to a BI tool like Power BI, the best option is to get a connector app from the Atlassian marketplace.

Here is the query to connectors for Power BI https://marketplace.atlassian.com/search?query=power%20bi

A few of the top ones offer instructions for connecting to Insight

[Robbe Van Laere]

@Robert Wen_Cprime_ , PowerQuery offers the option to do web requests. 

I tried the following, but I seem to get stuck with the IQL referencing. I basically want ALL objects from Schema 5. Do I need IQL for that? 

What would a GET look like? 

let
FetchPage = (url as text, pageSize as number, skipRows as number) as table =>
let
iqlval = "objectType=" & """test""" ,
contents = Web.Contents(URL&"/rest/insight/1.0/iql",[
Headers = [#"Content-Type" = "application/json" ] ,


RelativePath = "objects" ,
Query = [

objectSchemaId = "5",
iql = iqlval ,
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

[Robbe Van Laere]

Hi there! 
Found any solution on this ?