Insight and Power BI

Question

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,

Robbe Van Laere · Answer

@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

Robert Wen_Cprime_ · Answer

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 · Answer

Hi there! 
Found any solution on this ?