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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors