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.
I'm using the export to Power BI (M query) functionality thorugh azure log analytics.
The dashboard was working since a week ago, but now some log analytics query are giving me an error, but some not:
DataSource.Error: Web.Contents failed to get contents from 'https://api.loganalytics.io/v1/workspaces/xxxxxxxxxxxxxxxxxxx/query?query=Event%0D%0A%7C%20where%20EventLog%20%3D%3D%20%22System%22%20and%20Source%20%3D%3D%20%22Service%20Control%20Manager%22%0D%0A&x-ms-app=OmsAnalyticsPBI×pan=P7D&prefer=ai.response-thinning%3Dtrue' (400): Bad Request
Details:
DataSourceKind=Web
DataSourcePath=https://api.loganalytics.io/v1/workspaces/xxxxxxxxxxxxx/query
Url=https://api.loganalytics.io/v1/workspaces/xxxxxxxxxxxxxxxxxx/query?query=Event%0D%0A%7C%20where%20EventLog%20%3D%3D%20%22System%22%20and%20Source%20%3D%3D%20%22Service%20Control%20Manager%22%0D%0A&x-ms-app=OmsAnalyticsPBI×pan=P7D&prefer=ai.response-thinning%3Dtrue
Solved! Go to Solution.
Hi @Anonymous ,
There is a similar blog providing details about how to connect to API in Power BI, you can following the instructions in this blog to connect to your data source.
If you still get error, you can use Fiddler to track the process following the guide in this video.
In addition, you can refer this simliar issue and the blog which introduces Web.Contents():
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
There is a similar blog providing details about how to connect to API in Power BI, you can following the instructions in this blog to connect to your data source.
If you still get error, you can use Fiddler to track the process following the guide in this video.
In addition, you can refer this simliar issue and the blog which introduces Web.Contents():
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yingjl ,
I installed Fiddler and the actual error is:
{
"error": {
"message": "Response size too large",
"code": "ResponseSizeError",
"correlationId": "552a4fc6-dcd1-4d21-9fd0-d6523dd4af77",
"innererror": {
"code": "ResponseSizeError",
"message": "Maximum response size of 67108864 bytes exceeded. Actual response Size is 70694713 bytes."
}
}
}
Is it normal?
How can I fix it?
I have opened a new ticket: https://community.powerbi.com/t5/Power-Query/Log-Analytics-Response-size-too-large/m-p/1721870#M5223...
You response is correct to find the real error so I'll accept it
Same issue on my end. Our Log Analytics reports stopped working on Monday with the same error.
Change happened sometime between 12:00pm and 3:00pm EST on Monday March 8, 2021.
Thanks,
Craig
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.