Forum Discussion
Published dashboard failed to refresh data queried from SQL server
My published dashboard failed to refresh with this error I have checked the dataset setting page, and see only one credential for kusto However, in PowerBI PC client, there are two data...
Hi yifguo ,
It seems that your report contains two data sources (Kusto and SQL Server) based on your screenshots, Kusto has been added as data source in Power BI Server, but the SQL server still not be added... Did you install and configure any gateway before? The gateway is required if the data source is SQL Server. And if your dataset contains multiple data sources, each data source must be added within the gateway. You can refer to this documentation to add them within gateway.
In addition, please click "Edit Credentials " to update the credential of data source "Kusto".
Best Regards
Rena