Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Attempting to add credentials for Azure Data Explorer results in "We cannot apply operator &"

When I attempt to add my credentials, I see an error message that seems to have nothing to do with adding credentials! What do I do to fix this?

 

Refreshing my report works on Power BI desktop, so I don't think the issue is with my queries themselves.

 

gopalv_0-1597101337461.png

 

Status: New
Comments
v-yuta-msft
Community Support

@gopalv ,

 

Make sure data gateway has been updated to the latest version and check if the credentials in power bi service have been updated correctly.

 

Regards,

Jimmy Tao

YOCEL
Microsoft Employee

I've just had a similar issue, speaking to support today, we managed to fix it by updating the query in the desktop version. 

 

Go to Edit query and change: AzureDataExplorer.Contents() to Kusto.Contents()

 
Save and publish the report again and you should see your credentials now working properly.

 

gopalv
Microsoft Employee

Thank you, YOCEL, your workaround seems to have fixed my problem.

Anonymous
Not applicable

While this solves the problem with the credentials, for me there is now another problem with the report on Power BI service (everything works fine on Power BI desktop):

curichan_0-1639138117165.png