Data source error: DataSource.Error: <pii>Web.Contents failed to get contents from (long url here) 400): Bad Request. The exception was raised by the IDbCommand interface. Table: EventTelemetry.

[bfranco95]

What project is affected?

We are building a chatbot and utilizing the Analytics template for Power BI.

What happens?

Attempting to open the Power BI dashboard which has worked previously.

We get the following error:

Data source error: DataSource.Error: Web.Contents failed to get contents from 'https://api.loganalytics.io/v1/apps/a498620c-e2f1-4170-ab89-cb2412790836/query?query=customEvents%0A%7C%20project%20%0AActivityId%20%3D%20customDimensions.activityId%2C%20%0AActivityType%20%3D%20customDimensions.activityType%2C%0AChannelId%20%3D%20customDimensions.channelId%20%20%2C%20%0AConversationId%20%3D%20session_Id%20%2C%0AReplyActivityId%20%3D%20customDimensions.replyActivityId%20%2C%20%0AFromId%20%3D%20customDimensions.fromId%20%2C%20%0ALocale%20%3D%20customDimensions.locale%20%20%2C%0ARecipientId%20%3D%20customDimensions.recipientId%2C%20%20%0ASpeak%20%3D%20customDimensions.speak%20%2C%20%20%0AText%20%3D%20%20%20%20customDimensions.text%2C%0AEventName%20%3D%20name%2C%20%0ATime%20%3D%20timestamp%2C%20%0ADate%20%3D%20timestamp%2C%0ADialogInstanceId%20%3D%20customDimensions.InstanceId%2C%0ADialogId%20%3D%20customDimensions.DialogId%20%20%2C%20%0ADialogStepName%20%3D%20customDimensions.StepName%2C%0ALuis_ApplicationId%20%3D%20customDimensions.applicationId%2C%0ALuis_Intent%20%3D%2' (400): Bad Request. DataSourceKind = Web. DataSourcePath = https://api.loganalytics.io/v1/apps/a498620c-e2f1-4170-ab89-cb2412790836/query. Url = https://api.loganalytics.io/v1/apps/a498620c-e2f1-4170-ab89-cb2412790836/query?query=customEvents%0A%7C%20project%20%0AActivityId%20%3D%20customDimensions.activityId%2C%20%0AActivityType%20%3D%20customDimensions.activityType%2C%0AChannelId%20%3D%20customDimensions.channelId%20%20%2C%20%0AConversationId%20%3D%20session_Id%20%2C%0AReplyActivityId%20%3D%20customDimensions.replyActivityId%20%2C%20%0AFromId%20%3D%20customDimensions.fromId%20%2C%20%0ALocale%20%3D%20customDimensions.locale%20%20%2C%0ARecipientId%20%3D%20customDimensions.recipientId%2C%20%20%0ASpeak%20%3D%20customDimensions.speak%20%2C%20%20%0AText%20%3D%20%20%20%20customDimensions.text%2C%0AEventName%20%3D%20name%2C%20%0ATime%20%3D%20timestamp%2C%20%0ADate%20%3D%20timestamp%2C%0ADialogInstanceId%20%3D%20customDimensions.InstanceId%2C%0ADialogId%20%3D%20customDimensions.DialogId%20%20%2C%20%0ADialogStepName%20%3D%20customDimensions.StepName%2C%0ALuis_ApplicationId%20%3D%20customDimensions.applicationId%2C%0ALuis_Intent%20%3D%20customDimensions.int.... ;Web.Contents failed to get contents from 'https://api.loganalytics.io/v1/apps/a498620c-e2f1-4170-ab89-cb2412790836/query?query=customEvents%0A%7C%20project%20%0AActivityId%20%3D%20customDimensions.activityId%2C%20%0AActivityType%20%3D%20customDimensions.activityType%2C%0AChannelId%20%3D%20customDimensions.channelId%20%20%2C%20%0AConversationId%20%3D%20session_Id%20%2C%0AReplyActivityId%20%3D%20customDimensions.replyActivityId%20%2C%20%0AFromId%20%3D%20customDimensions.fromId%20%2C%20%0ALocale%20%3D%20customDimensions.locale%20%20%2C%0ARecipientId%20%3D%20customDimensions.recipientId%2C%20%20%0ASpeak%20%3D%20customDimensions.speak%20%2C%20%20%0AText%20%3D%20%20%20%20customDimensions.text%2C%0AEventName%20%3D%20name%2C%20%0ATime%20%3D%20timestamp%2C%20%0ADate%20%3D%20timestamp%2C%0ADialogInstanceId%20%3D%20customDimensions.InstanceId%2C%0ADialogId%20%3D%20customDimensions.DialogId%20%20%2C%20%0ADialogStepName%20%3D%20customDimensions.StepName%2C%0ALuis_ApplicationId%20%3D%20customDimensions.applicationId%2C%0ALuis_Intent%20%3D%2' (400): Bad Request. The exception was raised by the IDbCommand interface. Table: EventTelemetry.
Cluster URI: WABI-NORTH-EUROPE-E-PRIMARY-redirect.analysis.windows.net
Activity ID: 581d5133-34a5-4753-ba6b-5856687efe4d
Request ID: 3611ca5f-38b0-3d19-3a52-10f006cd859e
Time: 2021-08-10 12:10:56Z

What are the steps to reproduce this issue?

Re-deploying the template produces the same exact issue.

What were you expecting to happen?

We have been able to see the dashboard before, but now we cannot even see anything and just run into this error.

[bfranco95]

Checking for any updates here?

[ryanisgrig]

Hi @bfranco95,

I tested this afternoon on my end with a fresh install of the Virtual Assistant, new Azure resources and a new instance of the Power BI template. This works successfully for myself. I have a few questions to follow up:

• What version of the VA template are you using? Did the Power BI error occur after updating it or did it just stop working one day?
• Is telemetry still populating in the Application Insights resource as expected?
• What version of Power BI desktop are you using? See: Help > About
  
• Are you successfully authenticated to the App Insights data source? I am authenticated using my organizational account, you can verify under Home > Transform data > Data source settings > Edit permissions > Credentials: Edit
  

Tagging Support for backup!

[tomSauret847]

I ran into tis same issue. What we found was the app insights data was to large to pull from app insights. We ended up exporting app insights data to a Blob storage and then rebuilding the report to query the data from Blob as a work around to this issue.

[stevkan]

@tomSauret847, can you explain how you determined that the app insights data was too large to pull?