Connection to AzureDataExplorer (Kusto) works in Power BI Desktop RS but refresh fails

[AndyR123]

Hi,

we connect our Power BI Desktop RS to Kusto. Here the refresh works. After saving the Report to Premium on Premise server, refresh fails (not matter what credentials) with the message, that there are problems with the connection string.

Does anybody run a report with AzureDataExplorer? 

Thanks a lot.

Andy

[d_gosbell]

The on-prem Report Server does not support scheduled refresh against ADX / Kusto as documented here Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn - but since your data is already in the cloud couldn't you just put the report in a Power BI workspace?

[v-henryk-mstf]

Hi @AndyR123 ,

Can you provide some specific screenshots of the error messages or related log information for my further troubleshooting?

Looking forward to your reply.

Best Regards,
Henry