I have a report based on SQL server hosted on Azure. After publishing the report trying to add a vnet gateway for scheduling the dataset. However, It was throwing some unknown error while trying to assign the gateway. Later, found the datasource (SQL server) status is showing offline even though it was active and could run queries.
Could anyone please help me on this ?