Skip to main content
Question

Running into error when extracting data extract from Analytics to BI tools (PowerBI and Tableau)

  • December 31, 2024
  • 1 reply
  • 31 views

Forum|alt.badge.img+4

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. 

Did this topic help you find an answer to your question?

1 reply

HekateSwitch
Community Debut
  • Community Debut
  • 3 replies
  • January 1, 2025

Check your connection setup, ensure data format compatibility, verify access permissions, and reduce data size if needed. Look for specific error messages for better troubleshooting.


Reply