Forum Discussion
Error with Power BI Custom Connector -cannot convert a value of type Function to type Text.
Hi Xiaoxin,
Thank you for that suggestion. I've added in Diagnostics.Trace into my Test Connection expression. However there is nothing appearing in the logs. The connector works perfectly with Power BI Desktop, just not Service or data gateway. Updated code is here:
https://gist.github.com/jaimeblackwell/1e510ba24c4d71a0c5a6902e29e2da5b#file-gistfile1-txt-L4
Have I configured Test Connection incorrectly or is it a problem with my Data Gateway?
Thank you!
Hi jaime_blackwell,
If your data connector works well on the desktop side, I'd like to suggest you take a look at the flowing document about using a custom data connector with gateway and power bi service security. (power bi service has more limits on custom/development contents usage due to its security requirements)
Use custom data connectors with the on-premises data gateway
Power BI Security#data-storage-security
Regards,Xiaoxin Sheng