cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
peterg_intervat
New Member

Unable to read data from the transport connection:

Hi

 

So aver the last two to three days I am having a varieity of issue with my Odata connection to CRM online. At first it was complaining with teh following error when trying to refresh the datasource:

 

"Data response result. Error: The property 'bizmap_businessid_businessunit' does not exist on type 'Microsoft.Crm.Sdk.Data.Services.BusinessUnit'." - So i assumed that a field that was part of a dataset had been changed, so i rebuilt the query in PowerBi Desktop (testing the refresh with no error" and republished.

 

Has the same issue again, which is odd as i tested the refresh on the desktop publisher with no errors.

 

Then forced a refresh again a few hours later and get a different error:

"Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host."

 

The odd thing is that this all worked fine for about 1 month up until 2 days ago.

 

Does anyone have any ideas.

 

Thank you in advance

13 REPLIES 13
Deiaeldin80
New Member

This issue happened with my while running several Dataflows from datasource folder in Onedrive or sharepoint, it kind of make sense that the source folder serve only one connection at a time, i resolved it by running schedual refresh time of my dataflow in a way that allow not more than two dataflow connections to hit the source folder at the same time, depends (offcourse on the datasize) leaving a reasonable gap to (30 Minutes) between every connection. it might not be a perfect solution but it gets the job done eventually 🙂

saunders
Helper II
Helper II

Hey, just wanted to add that we're getting this error as well.  Are there any other logs we can check in PowerBI to get more of an idea of what's going on?  If any find a solution can you pls post.

Thanks heaps.

Hi @saunders,

Yes Saunders, I have used fetchxml as part of web query to extract data. I have also submitted a blog for same.

However it is pending for approval from Microsoft.

 

BR,

Achin

Hi I'm also eager to read your blog posting to resolve this problem. Did your blog posting ever get approved or can we see the info on some other non MS approved blog ? Please do let us know.

 

Trying to resolve a Power BI desktop connection to Dynamics 365 online instance using:

let
Source = OData.Feed("https://DOMAIN.crm4.dynamics.com/XRMservices/2011/OrganizationData.svc"),
ContactSet_table = Source{[Name="ContactSet",Signature="table"]}[Data]

 

Will be checking logs, fiddler etc....but still keen to read your blog.

Thks.

Hi @DavidMoss,

 

Please check this URL :

My blog was published few months back.

 

https://community.powerbi.com/t5/Community-Blog/CRM-Online-issues-with-oData-and-solution-with-Fetch...

 

Please do let me know if you have any questions.

BR,

Achin

achinm45
Advocate IV
Advocate IV

Hi @peterg_intervat

Have you got the solution ?

 

BR,
Achin

Hi there

 

No solution to this yet. This problem comes and goes. Which sadly impacts the business case to make it a permanent solution. I am not sure if it has to do with the fact that the feed timesout. It would be awesome if the feed would be more "real time" 🙂

 

Kind regads

Hi @peterg_intervat

Thank You for information !

I am also using CRM Online. Now I suspect, CRM online can also be possible suspect for problem.

Do we have setting where CRM online closes the connection ? I am not CRM online expert but do you have any idea

 

BR,

Achin

Hi @peterg_intervat, @solaris_rapido

I have published a blog for this issue and solution to it.

 

Please do check it here

 

I hope it helps you !

BR,

Achin Maheshwari

 

 

Hi @achinm45

 

Thank you for this. Seems like i dont have access to this. Any Chance you can grant me access. I would really be interested to see your solution.

 

Kind regads

Peter Gaertner

Hi @peterg_intervat,

I am unable to find any acess button or functionality for providing you access.

Seems Power BI team has not reviewed the article yet. It is in my staging area and has not been published to all.

I will post again on this forum when the blog gets published.

BR,
Achin

solaris_rapido
Microsoft
Microsoft

I'm getting the same error for the past two days even though mine was also working fine up to then.

Hi @solaris_rapido

Has your issue been resolved and how ?

I am facing same error and not getting a hint.

 

BR,

Achin

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors