Power BI schedule failed with the Below Error

[Makula9989]

Spoiler

Hi all,

I got a power BI report with Azure as a Data source Azure IaaS (SQL Server running as a virtual server in Azure).so I had installed the Enterprise gateway 

However, when I try to setup a daily scheduled refresh, I'm receiving the following error:

Note: all the credentials are working fine and its been Processing for some time and throwing the below error 

 

Please let me know how to resolve this issue ??

Thanks

Mano

[GilbertQ]

Hi @Makula9989

Can you confirm if you have downloaded and installed the latest On-Premise Gateway?

They have created some great new features as well as tests to ensure that the connectivity is working as expected?

Also has anything changed in your network that could be affecting the Servers connectivity?

Power BI Gateways - March Update

[Makula9989]

Hi Guavaq,

As you suggest i had unistall the On premises gateway and installed the latest version and try to refresh but now got 

[GilbertQ]

Hi @Makula9989

You can confirm that when you test the Data Source it does say that the connection is successful?

[Makula9989]

yes it is showing the two datasources as success and i had tried to refresh on demand and its running and after some time its throwing error 

Thanks

Mano

[GilbertQ]

Hi @Makula9989

What I would then suggest is to enable the Verbose Logging to the Log File.

And then refresh and once it fails review the log file, as I am sure that there will be some information in there as to why it is failing.

[Makula9989]

Thanks for the Quick response guavaq

How to enable the enable the Verbose Logging to the Log File ..Is it in Power BI gateway ??

[GilbertQ]

hi @Makula9989

Here is the offical blog post by Microsoft Power BI Team

Power BI Gateways–March Update

And here is where you can set the Verbose Logging