Forum Discussion

Lucian's avatar
Lucian
Responsive Resident
3 years ago
Solved

How to find which OData version I'm using?

Hello,   As Microsoft anounced "OData v2.0 Service removal date announcement", is there any way to detect which OData version I'm currently using in my Power BI reports so I will not have problems ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Lucian Well this is the email I received below. In re-reading this about 12 times. I *think* that the Instance Web API is the Web API, an OData 4.0 service that they mention. So safe *probably*? 

     

    As previously announced in our blog post, on Sunday, April 30, 2023, we plan to remove the Organization Data Service, an OData v2.0 endpoint that was introduced with Dynamics CRM 2011. This service was also known as the OData endpoint or the REST endpoint when it was released, and offers limited capabilities to only create, retrieve, update, or delete table data. This service was deprecated with the introduction of Dynamics 365 Customer Engagement v8.0 in favor of the Web API, an OData v4.0 service.
     
    Note: This announcement does not involve the deprecated Organization Service SOAP endpoint. At this time, no date has been announced for the removal of that endpoint.
     
    How does this affect me?
    As we plan to remove the Organization Data Service on Sunday, April 30, 2023, you may experience functionality failures of any code utilizing this service. To avoid interruptions of service functionality, we recommend that any code that uses the Organization Data Service should be migrated to use the Web API before that time.
     
    What actions do I need to take?
    To avoid impact to your code, please use one of the following methods:
    1. Use the Solution Checker to detect any JavaScript web resource code. The rule web-avoid-crm2011-service-odata should detect use in client-side code.
    2. Check any other code, including PowerShell scripts, that send requests to this endpoint: xrmservices/2011/organizationdata.svc
    3. Check any Power BI reports or Excel Data sources that may be using this endpoint.
    4. Please review the information in the best practices documentation for information to upgrade the code to use the Dataverse Web API: Do not use the OData v2.0 endpoint.
lkay's avatar
lkay
Frequent Visitor
3 years ago

Thanks Lucian - I also had the same question this morning. 

 

Greg_Deckler do you mind kindly elaborating on what you mean by "source systems for what version of OData they support".

 

In the past, this is how I connected powerbi to CRM data:

 

Then fetching the instance Web API link from Customizations --> Developer Resources --> Instance Web API:

 

 

and then I pasted here:

 

 

 

Echoing the question that was posted: any way to detect which OData version I'm currently using in my Power BI reports ?

 

thank you!

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    lkay Lucian My understanding according to the email that was sent out is that OData endpoint is going away completely and you need to convert these to use the Dataverse connector. So if you are using the Dynamics 365 Online (legacy) connector you will have to change it. It's not that there is some other OData version of that endpoint that you can use. Sorry, the whole version of OData thing threw me off.

     

    My understanding is that the Dataverse connector uses OData 4.0.