Getting The underlying connection was closed

[ahsiddiqui]

I developed my own dashboard and displying powerbi dashboad and reports with dataset refresh feature. it was working fine for the last one year but for the last few days suddenly it stop working and showing "The underlying connection was closed: An unexpected error occurred on a send".

Just for more clarity i was following below steps to refresh the dataset as well as display reports

Refresh Data set:

1. Generate the Access token : getting access token 

2. call API https://api.powerbi.com/v1.0/myorg/groups/{0}/datasets/{1}/refreshes   passing groupid, datasetid, token etc

Here i am getting error: "The underlying connection was closed: An unexpected error occurred on a send"

Same error while try to get information for reports.

[lbendlin]

is your capacity running hot?  Check the health dashboard for memory starvation, excessive ejections, or other signs of being overwhelmed.

[ahsiddiqui]

Thanks for quick response.

I am not aware how to reached to health dashboard. Please share more detail.

[lbendlin]

sorry, I thought this was available outside Premium too. My bad.

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-premium-monitor-capacity

[ahsiddiqui]

Just for your reference i have pro licence only. link shared ny you for Premium licence. my reports were working fine and refresh dataset also.

Suddently from last week it stop working ansd showing error . Still embeded trail token showing 75%.

[ahsiddiqui · Accepted solution]

issue resolved with the help of microsoft support. 

Support for transport layer security (TLS) 1.0 and 1.1 for Power BI will end in June 2020. Upgrade the TLS version of your Power BI application to TLS 1.2 before then. 

Solution: Adding followung code  

System.Net.ServicePointManager .SecurityProtocol = SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12; 

Follow below post suggested by microsoft support team:

https://azure.microsoft.com/en-in/updates/power-bi-support-for-transportlayer-security/

https://community.powerbi.com/t5/Issues/Embedded-Power-BI-is-not-working/idi-p/1185996#comments

[Wilhelm]

I'm running Windows 11 Pro for Workstations on .Net version 4.8.09032. A few days ago this suddenly started happening to me too (without any warning). Any idea whether this is specific to the Workstations version of Win 11?

[ahsiddiqui]

Microsoft provides some free tokens to display reports/dashboards on the web page (embedded). Once the free token finishes/consume reports/dashboards stop working. To display reports/dashboards on a web page (embedded) you need to have a premium license, which is very costly.