Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
501 questions
Web content failed to get content error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 6%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mehala Muthiah
0
Reputation points
We are importing ADX(kusto) dataset in Power BI using direct query mode. Since we scaled up the cpu count in ADX, the visuals got crashed in Power BI desktop/Service and got the below error.
Web.Contents failed to get contents from 'https://(Clustername.location.)kusto.windows.net/v1/rest/query?db=(database)&csl=.show%20version' (520): InternalServiceError
But the query and tables are working fine in ADX, only in Power BI we are facing the issue. For every refresh, Some of the visuals are working and some of the visuals are crashing. Its soo weird and we can't recoginze the rootcause of this issue. Even I tried to create a new Power BI report using the ADX connection string, i got the same issue.
once we scale down and return back to the previous state of cpu count. The reports are coming up and working fine. Due to the performance issue, we are in need of scaling up the cpu count in ADX which results in crashing power bi reports. Need help to resolve this issue!
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT 28,526 Reputation points Microsoft Employee2024-03-12T20:27:09.4366667+00:00 Hello Mehala Muthiah,
Welcome to the Microsoft Q&A forum.
The issue you are facing due to throttling. You likely returning too much data to the PBI.
You need to optimize your Power BI query so that it doesn't take as much memory.
As next steps, can you try limiting the data pulled into Power BI by filtering or aggrate at the query level and see if it helps.
-
BhargavaGunnam-MSFT 28,526 Reputation points Microsoft Employee
2024-03-18T21:22:31.6166667+00:00 Hello Mehala Muthiah,
I am checking to see if you had a chance to look into my above response.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 20%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mehalam 0 Reputation points2024-03-20T10:30:52.35+00:00 Thanks for your prompt response.
Yeah we filtered out the pulling data to last 30 days which reduced the loading time.
But the issue was not that.Once scale up the ADX CPU Count, the visuals are loading into the above error even I pulled last 1 day data (not more than 10k row data).
-
BhargavaGunnam-MSFT 28,526 Reputation points Microsoft Employee
2024-03-22T20:27:17.95+00:00 Hello Mehala Muthiah,
Thanks for the additional details. This issue seems to be strange.
If you have a support plan, please log a support ticket so that a support engineer can further troubleshoot the issue in a screen-sharing session.
If you don't have a support plan, please let me know so that I can provide a one-time free support request to work on this case.
I am looking forward to hearing from you.
Sign in to comment