Power BI frequent OLE DB or ODBC errors with ADLS as data source

[mgrewal]

Ive created a PBIX that reads JSON files stored in Azure Data Lake Store. During my azure trial period, the reports and queries I created worked great. In the last few weeks since my trial ended and I have a pay as you go subscription, I frequently get the following error message in PBI when refreshing my data:

OLE DB or ODBC Error: [DataSource.Error] Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host..

It doesn't happen always. At the time of creating this post, I subsequently re-ran the data refresh and was successful. It doesn't seem to consistent with number of rows returned. A day ago I was able to return over 10 million rows in a report and today I was struggling getting 813k rows to return.

Anyone else have this issue?

[Maggie_Chan]

same issue here, any solutions?

[jamespusateribp]

happening on bp-vsts.visualstudio.com instance...

OLE DB or ODBC error: [DataSource.Error] OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host..

[Eric_Zhang]

---

@mgrewal wrote:

Ive created a PBIX that reads JSON files stored in Azure Data Lake Store. During my azure trial period, the reports and queries I created worked great. In the last few weeks since my trial ended and I have a pay as you go subscription, I frequently get the following error message in PBI when refreshing my data:

OLE DB or ODBC Error: [DataSource.Error] Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host..

It doesn't happen always. At the time of creating this post, I subsequently re-ran the data refresh and was successful. It doesn't seem to consistent with number of rows returned. A day ago I was able to return over 10 million rows in a report and today I was struggling getting 813k rows to return.

Anyone else have this issue?

---

@mgrewal

This error usually means the target servier is running, but the service connected is not available. Is the data lake store locates in the same or closer data center? You can find where your Power BI data is stored by clicking the question mark.

For better support, I'd suggest you submit an Azure support ticket or Power BI support ticket.

[mgrewal]

Hi @Eric_Zhang, 

I'm running Power BI Desktop and don't see that toolbar with the question mark. The Data Lake is Central US and I'm in Western Canada.

I contacted Azure Support and they recommended I post in this forum.

[sukajalan2]

I had exactly the same problem with my report (3M+ rows). The data source files are in SharePoint. It was working fine until about 12 hours ago, I keep refreshing every hour or so and now it is working again.