Error with Scheduling with Custom connector

[learner03]

Our warehouse uses warehouse management system and I receieved a custom connector from them to use in Power Bi for creating dashboards. I have now created Dashboard and want to set schedule for every hour and wish to share with people in organisation. 

I published it in Power Bi service but when I tried to set Schedulat it gave me an error as below-

After that, I got another error as below-

How can I fix this issue. Please help.

Thanks

[v-deddai1-msft · Accepted solution]

Hi @learner03 ,

Yes, your custom connector don't support scheduled refresh as mentioned : For custom connectors to work with the on-premises data gateway, they need to implement a “TestConnection” section in the custom connector’s code. This section isn't required when you use custom connectors with Power BI Desktop. 

The workaround I can think of is to export data from data warehouse to some other data source(like sharepoint ). Then you can connect to the data source avoid using the custom connector.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[arvindsingh802]

You have to configure the custom connection on your gateway machine before making the connecion 

Use custom data connectors with the on-premises data gateway - Power BI | Microsoft Docs

If this post helps, then please consider Accept it as the solution and give it a thumbs up

[learner03]

Hi @arvindsingh802 , Thank you. I read the document and based on that I asked the question to the team from warehouse managmn system who gave me the custom connector, if they have TestConnection handeler while making the custom connector and they sent me the below reply-

"We don't have the infrastructure setup for a Microsoft On-Premise’s gateway, we are looking into setting this up in near future"

Does this mean that I can't schedule refresh? or is there any other way to publish and schedule to power bi service? Please help as I am not strong at technical front. What can I do to make it work?

Thanks