Forum Discussion
power embedded intermittent loading issues, powerbi requests hanging, urls stuck in pending
Similar to
we have times that report loading just hangs (forever) because the conceptualschema and modelsAndExploration urls get stuck in pending.
Sometimes change browers seems to fix it, or coping the url (with headers) and curling works as well, 200response.
there are a few similar issue that return 401s, however we just get stuck in "pending"
Does anyone have any ideas?
7 Replies
Hi timker,
What type of data source your report used? Did your report deploy on the region that your data source hosts? BTW, is this loading issue appear on the original reports?
Please share some more detailed information to help us clarify your scenario:
How to Get Your Question Answered Quickly
Regards,
Xiaoxin ShengIt is a Import Dataset (Not Direct or Hybrid).
Our customes say it is happening to other reports as well. (we have a few hybrid reports, for rls)
Our Power BI is Generation 1, Australia Southeast
I wouldn't know how to change the dataset location, So I'm fairly confident it's in the same location
How our Hybrid App, we the database is located "Australia East", however because the issue has happened on Non-Hybrid I suspect this isn't the issue.
"is this loading issue appear on the original reports? "
I'm not sure I understand the question, It's happening on serveral reports. It's hard to tell how often as It's in an iframe.
I've added some logging to try and detect slow report loads
I've increased our AzureSQL DTU's so that we don't have any slow queries
the longest running query today was 13seconds
So It looks like SQL does not have anything to do with it.
Does anyone else know what could be causing the slowness?
I've Replicated the Issue in https://app.powerbi.com/home
All I need to do is try and create a new report (with no data) and conceptual schema will hang in "pending"
After 2.1minutes it gives up and I get an net::ERR_HTTP2_PROTOCOL_ERROR
opening a new incognito window does not have this problem
Copying the request as powershell request (inluding all headers/bopy), works no problem
HI timker,
>>Does anyone else know what could be causing the slowness?
Normally, it can be related to the network status and server workload. Did this issue appear regular or at special time periods?
In addition, please also check the gateway connections and the device idle resources that you host the gateway client. (they may affect the response of refresh and data loadings operations that reduce the performance of report usage)
>>opening a new incognito window does not have this problem
Have you saved the accounts at the quick login in the menu? If the 'private mode' does not show the issue, it may cause by the saved credentials. (they may conflict at SSO verifications steps)
Regards,
Xiaoxin Sheng
Hi Xiaoxin Sheng,
I don't believe it is network slowness or Network overload, as I can switch browers and it works.
It is also unlikely that it is saved credentials,
because A) I can copy the full request and it will curl just fine
b) this issue is occurs in embedded where there is no SSO
Thanks for the reply
