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 :)
Greets
Norbert
Norbert_L
Offline
Last seen: 1 year 1 month ago
Joined: 09/03/2014 - 10:37
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.
Brian
Hi Brian,
thx for your hints.
Greets Norbert
Just another thought. If you are using 10.4 or higher you could extract the data to python and have ptyhon create the json file.
Brian please let me correct you it works with 10.3 and higher.
Hi klmi, thanks for the correction.