Reply
Highlighted
Frequent Visitor
Posts: 4
Registered: ‎04-21-2017

Linking report data from Insightly

Hi all,

 

I am creating report from Insightly web application, and I need to link the following:

- Opportunity name

- Opportunity tasks

- Opportunity categories

- Organizations linked to opportunities

- Opportunity stages

 

This is at leasI need. I tried in Insightly to create similar report but Tasks are not linked to Opportunity & linked Organizations.

Also I created custom categories in Tasks in Insightly but PowerBi doesn't see all of them - just 4 categories only. Checked all that they are not empty...

 

Thanks in advance!

Moderator
Posts: 2,516
Registered: ‎03-06-2016

Re: Linking report data from Insightly

Hi @Sandros1939,

 

It seems that you are getting data use Insightly content pack on the Power BI service, and some tables are not linked, right?

 

Dataset got from the Insightly content pack is out-of-the-box, we are not able to create relationship on Power BI service. In your scenario, you can try to call Insightly API in Power BI desktop, then manage relationship for retrieved tables.

 

Best Regards,
Qiuyun Yu

Frequent Visitor
Posts: 4
Registered: ‎04-21-2017

Re: Linking report data from Insightly

Hi Qiuyun Yu,

 

Thank you for your reply. Can you please tell me how can I get data from Insightly at Power BI Desktop using my API key? I couldn't find how to do it...

Thanks!

Moderator
Posts: 2,516
Registered: ‎03-06-2016

Re: Linking report data from Insightly

Hi @Sandros1939,

 

It depends on the syntax of Insightly API call. You can take a look at a sample which pass API key at the end of the URL in Web data source: Calling REST APIs and Parsing JSON made simple with Power BI .

 

Best Regards,
Qiuyun Yu