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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

Power BI Log Analytics for Analysis Services Engine failing on refresh

We have had the Power BI Log Analytics for Analysis Services Engine refreshing successfully until last week (July 30).  The error message is: 

Data source error: Web.Contents failed to get contents from 'https://api.loganalytics.io/v1/workspaces/<guid>/query?query=%0Aset%20notruncation%3B%0A%0A%0Alet%20startDate%20%3D%20startofday%28ago%2827d%29%29-%20-300m%20%3B%0Alet%20startIngestionTime%20%3D%20datetime_add%28%27hour%27%2C%2020%2Ctodatetime%28startDate%29%29%3B%0Alet%20endIngestionTime%20%3D%20datetime_add%28%27hour%27%2C%204%2Ctodatetime%28startIngestionTime%29%29%3B%0A%0APowerBIDatasetsWorkspace%20%0A%7C%20where%20TimeGenerated%20%3E%3D%20startIngestionTime%20and%20TimeGenerated%20%3C%20endIngestionTime%0A%7C%20where%20%28OperationName%20%3D%3D%20%27VertiPaqSEQueryEnd%27%20and%20OperationDetailName%20%3D%3D%20%27VertiPaqScan%27%29%20%2F%2F%20Queries%20with%20EventSubclass%20%3D%200%0A%20%20%20%20%20%20or%20OperationName%20%3D%3D%20%27DirectQueryEnd%27%20%2F%2F%20Queries%0A%20%20%20%20%20%20or%20OperationName%20%3D%3D%20%27VertiPaqSEQueryCacheMatch%27%20%2F%2F%20Cache%20hits%0A%7C%20extend%20TextDataHash%20%3D%20hash%28EventText%29%0A%7C%20extend%20Dur' (400): Bad Request. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
Cluster URI: WABI-US-NORTH-CENTRAL-G-PRIMARY-redirect.analysis.windows.net
Activity ID: 413ad8fa-89c2-9ee1-de6a-9f73c0cde61d
Request ID: 25a406e8-f0b2-4bd9-ded5-9150fd7294c5
Time: 2022-08-01 11:57:09Z

5 REPLIES 5
v-xiaoyan-msft
Community Support
Community Support

Hi @Anonymous ,

 

We still need to troubleshoot the issue further, and we will give you feedback here if there is any progress on this issue.

 

 

Best Regards,
Community Support Team _ Caitlyn

v-xiaoyan-msft
Community Support
Community Support

Hi @Anonymous ,

 

I wasn't able to reproduce your question.
According to your description, is this problem without doing any additional operations it suddenly appeared?
A few days have passed since you posted, did you retry today to see if it has returned to normal?

 

Best Regards,
Community Support Team _ Caitlyn

Anonymous
Not applicable

After redeploying the template app on (updated 8/2) on 8/4 it works. 

They were a day late with internal changes. 

 

Anonymous
Not applicable

I was able to capture the queries against the Power BI Log analytics workspace.  The queries have WorkspaceID and WorkspaceName,where the logs have PowerBIWorkspaceId and PowerWorkspaceName.   I can't download the report / dataset.  Would anyone know who to contact on this issue?

Anonymous
Not applicable

FYI   The https://aka.ms/BYOLATemplateAppsDocs_AS link for on the Template App support section and in the "Help" page doesn't work. 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.