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.
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
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
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
After redeploying the template app on (updated 8/2) on 8/4 it works.
They were a day late with internal changes.
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?
FYI The https://aka.ms/BYOLATemplateAppsDocs_AS link for on the Template App support section and in the "Help" page doesn't work.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.