exporting to json

2 posts / 0 new
Last post
Norbert_L's picture
Joined: 09/03/2014 - 10:37
exporting to json

Hi Brian, 
do you know if it is possible to export data from IDEA to the json format?
I would like to export the data within our script and import it to PowerBI.
I havent found anything in the menus or the internet - so I've planned it to export to a delimited utf8 file as workaround.
Thx in Advance :)

Brian Element's picture
Brian Element
Joined: 07/11/2012 - 19:57

Hi Norbert,

There is no option to export to json but there are a few options for you.  Depending on the version of IDEA you are using you could create ODBC drivers to allow Power BI to connect directly to IDEA.  That is what I am doing in one of the projects I am working on.  Another option is to output the information as a text delimited file and then use that in Power BI.