Forum Discussion
Error with Power BI Custom Connector -cannot convert a value of type Function to type Text.
Hi All, I'm building a custom connector for Power BI that queries Xero's API. When used in Power BI the connector returns an error after successful authentication "We cannot convert a value of ...
HI jaime_blackwell,
This seems like a common error notice, and it appears when you try to do type conversions or use M query functions with wrong data types.
In my opinion, I'd like to suggest you add some 'debug output' codes into your connector to output the logs to the debug panel and help you trace/locate the M query processing steps. (it should help us to find out which steps cause the issue)
Regards,
Xiaoxin Sheng