Forum Discussion
Configuring on premises data gateway for custom connector
- 3 years ago
I managed to figure out why my connector was working. Basically there are datatypes that are allowed as parameters in power bi desktop that aren't allowed in Power BI service. In my case I was using time and list data types which works fine in Power BI Desktop but not in Power BI Service. My suggestion is if you are using types that aren't support in Power BI Service you just have to make them optional and the connector will work just fine.
Kind Regards,
Hi, if you already have a gateway and you are building this just for connectors, then you can add it as cluster to that one. If not, then it might not be necessary. You can read the following instructions to check every step:
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-custom-connectors
I hope that helps,
- Bokangmaela3 years agoHelper I
Hi, Thanks for the response.
I have followed the steps outlined in the link. Here is my on premises gateway
Here is the gateway configuration on Power BI service
For this gateway I added username and password option in my custom connector. I cleared all persmissions in power bi desktop and added my username and password. I publised the report to power bi service but now I recieve the follow error.
I am not sure why I am recieving this error. When I try and add a new connection in Power BI service my datasource type still doesn't appear as explained in the link you have sent. Please help where possible maybe I missed something.