Have you installed the personal gateway on the machine where your dataset locates?
If you want to use on-premises gateway, have you installed and configured the on-premises gateway for this dataset? You can see the on-premises gateway status and add data sources in “Manage Gateways”.
I have caught the problem. But still not able to figure out the correct solution.
My dataset contains 2 SQL tables and one table from Kusto Cluster.
Normally, Kusto cluster does not require any data gateway. It simply uses Web in Data Source Credentials.
Previously, it was not showing my data gateway. Once I added the Kusto Cluster in my data source it started showing Gateway when I was trying to schedule refresh. Hence, above problem is resolved for now
But there is new problem. Refresh is failing with below message.
I have already tried it giving "https://ptpedge.kusto.windows.net/" as URL and also altered the credentials from Anonymous/Basic/Windows. But this is not helping
Any updates on this issue.
How do we have SQL Tables and Kusto Cluster Tables together in a data gateway??
If the gateway is configured properly and shown as online, the refresh should work well.
I suggest you to create a support ticket at http://support.powerbi.com (see bottom of page) since it may be account specific.
@v-haibl-msft I don't think its account related problem.
Yes datagateway is showing online. Even all connections are successful.
I believe here is the problem. For Kusto, I have to give DataSource Type as Web.
And Kusto Cluster works on OAuth. In data gateway I am not seeing this option.
While if I give Kusto cluster directly in Web Credentials it shows OAuth.
But here I need to give in data gateway because I have SQL Tables too in the same datasource.
Please find the below screenshot. Let me know if there is any fix or my account needs special authorization for this.
Can someone confirm if Kusto cluster data source needs a gateway? I'm suspecting no since it is cloud based authentication. If so, just wondering is there documentation on which data sources requires gateway, which ones don't?
Your help is much appreciated.