04-21-2017 04:58 AM
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!
04-24-2017 12:52 AM
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.
04-24-2017 03:20 AM
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...
05-04-2017 07:44 PM