cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
PowerBIsucks
Frequent Visitor

OData feed D365 Connection Error

Hello Community!

We recently enabled a connection to the D365 entities via ODatafeed. After being super exicted in the first place, I got a little setback. My two main concerns are 1. Connection Errors and 2. Speed. 

 

With some entities I don't have any problems to connect to but others return the following error:

"Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] OData: Request failed: The remote server returned an error: (400) Bad Request. (An error has occurred.). OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.'.

 

Now comes the best part: When I click "apply changes" within power bi after my load failed, the connection works, although it is extremly slow.

At other times everything just seems to be working fine (depending on the table).

 

I was wondering: Does anyone have similiar issues or solved such a issue? Maybe you could point me in the right direction. Unfortunatly I could not find any useful documentation for D365 from MS, nor could our so called external D365 "experts" help wih the issue. I strongly hope you can!

 

Best,

Nico 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: OData feed D365 Connection Error

Hi @PowerBIsucks 

Do you connect to Dynamics 365 on-premises or online?

If it is online,Are you able to access Dynamics 365 from web browser?

It should work with Get Data-Dynamics 365 Online connector following the guide in this article.

 

From your information, it seems the connection finally works but slow, right?

If so, it may be a network connection issue... It maybe blocked by a firewall, there may be a problem with DNS or something.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support
Community Support

Re: OData feed D365 Connection Error

Hi @PowerBIsucks 

Do you connect to Dynamics 365 on-premises or online?

If it is online,Are you able to access Dynamics 365 from web browser?

It should work with Get Data-Dynamics 365 Online connector following the guide in this article.

 

From your information, it seems the connection finally works but slow, right?

If so, it may be a network connection issue... It maybe blocked by a firewall, there may be a problem with DNS or something.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

PowerBIsucks
Frequent Visitor

Re: OData feed D365 Connection Error

Hi Maggie,

 

Thank you very much for your reply. You hint to try the URL access via a webbroser seems now obvious to me in hindsight.

I thought I have full access but after copying the URL of the entity directly in the browser I got a meaningful error message: 

"<Error>
<Message>An error has occurred.</Message>
<ExceptionMessage>
User is not authorized to read view InventTransferOrderHeaderEntity. Request denied.
</ExceptionMessage>

...."

So, it was a problem with access rights. Thank you very much for pointing me there. As for the other behavior it is indeed connected to the network speed. But the question is  still why it so slow (all other server connections run super smooth and fast).

Going to troubleshoot this with our IT and MS. If it is an issue on MS side I would add it here later to show how it was solved. But at least I got now access to the data. 

Thanks again!

 

Best,

Nico

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors