Hello,
I referred to these two documentations 50000003101 and 50000001123 to connect two BI tools (PowerBI and Tableau) to a data extract I created.
I used my API Key for Username and provided blank for password as instructed. I also checked Analytics page to confirm the data/report was certainly generated and i can download it using that page. However, connecting it from BI tools would run into below errors.
Error from PowerBI:
Details: "Web.Contents failed to get contents from 'https://helpdesk./domain name].org/api/v2/analytics/export?id=223adc3d-52fd-4bf5-b518-17f1216fedeb' (404): Not Found"
Error from Tableau: An error occurred while communicating with the data source
The web data connector returned invalid data.
Error Code: 95BE3012
Either invalid data are present or required fields are empty for class TableInfo. Required fields and respective data types are: { (Name : 'id', Type : QString, IsRequired : true),
(Name : 'columns', Type : QVariantList, IsRequired : true),
(Name : 'alias', Type : QString, IsRequired : false),
(Name : 'description', Type : QString, IsRequired : false),
(Name : 'incrementColumnId', Type : QString, IsRequired : false),
(Name : 'joinOnly', Type : bool, IsRequired : false)
}
Is there anything else i can check? My FreshService account is escalated to Admin and the error would persists.