cancel
Showing results for 
Search instead for 
Did you mean: 

After upgrade Odata functions are missing in connector

Hi,

After making the upgrade from PowerBI Desktop feb 2018 to june 2018 version, i can now no longer see functions in the odata Navigator. It only displays the "tables".

I tested on multiple computers and also with the below public odata service:

http://services.odata.org/TripPinRESTierService/

 

You can see in the screenshot left is excel(correct) and right is powerBI(missing functions).

Capture.PNG

Status: Accepted
Comments
New Member

Hi,

After making the upgrade from PowerBI Desktop feb 2018 to june 2018 version, i can now no longer see functions in the odata Navigator. It only displays the "tables".

I tested on multiple computers and also with the below public odata service:

http://services.odata.org/TripPinRESTierService/

 

Community Support

Hi @TimVe,

 

I have reported this issue internally: CRI 75688223. Will update here once I get any information. 

 

Best Regards,
Qiuyun Yu 

Impactful Individual
Status changed to: Accepted
 
Regular Visitor

This is a behavioral change we're trying out for new connections in the June 2018 release. If you go to http://services.odata.org/TripPinRESTierService/ in your browser, you'll notice that the functions are not represented there either. Before the June release, we would try to infer the locations of functions, but the OData protocol does not actually guarantee we can do this if they are not represented in that top-level document. For June, we tried to go with the strictest possible interpretation, but there's definitely still some question on what the best behavior would be. Old connections are unaffected, and you can always revert to the pre-June version of the connector by going to the Advanced Editor and removing the option 'Implementation = "2.0"'.

New Member

Thanks for the feedback. 

The problem is that the option in the advanced editor can only be removed after the data connection is already made and data loaded.

The navigator is used for making new connections and so then we have no way to see the existing functions except to go looking in the odata service $metadata page.

Regular Visitor

We have the same issue as TimVe above. If this could be an option within Power Bi & Excel so at least the user can turn "Implementation="2.0" off. Otherwise how do we display the functions in the UI?  The service document according to the std does not allow this?

This is a key piece of functionality that's no longer available.

See this thread for more information.
https://blog.crossjoin.co.uk/2018/06/27/odata-performance-power-bi/

Regular Visitor

Issue exists now in both Excel and PowerBI...

The Navigator does not show any function anymore...

 

Is there anything that should be change in the http://services.odata.org/TripPinRESTierService/$metadata in order to display them ?

(note that that page is coming from OData.org, so supposed to be a reference)

 

Like others, the removal of functions from the Navigator is considered as a big regression as it remove the sort of wizard guiding the user in the use of them...

Regular Visitor

I agree with user "vco" - please can someone at MS address this or update us on this? @v-qiuyu-msft  

Regular Visitor

If of any use for other users, please note that it is possible to get previous version from:

https://zenatti.net/2017/07/04/power-bi-previous-versions/

 

I hade to download the may version from there in order to get back the navigation.

 

But would really like to see it working back in the current version...