After upgrade Odata functions are missing in connector

Status: Accepted
by TimVe Occasional Visitor on ‎07-03-2018 06:41 AM

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
by TimVe Occasional Visitor
on ‎07-03-2018 02:51 AM

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/

 

by Moderator v-qiuyu-msft
on ‎07-04-2018 12:40 AM

Hi @TimVe,

 

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

 

Best Regards,
Qiuyun Yu 

by Vicky_Song Established Member
on ‎07-04-2018 12:40 AM
Status changed to: Accepted
 
by ergore Visitor
on ‎07-06-2018 04:29 PM

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"'.

by TimVe Occasional Visitor
on ‎07-09-2018 01:48 AM

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.

by widget73 Visitor
on ‎07-12-2018 01:32 AM

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/

by vco Visitor
on ‎08-03-2018 08:24 AM

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...

by widget73 Visitor
on ‎08-03-2018 08:28 AM

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

by vco Visitor
on ‎08-03-2018 08:37 AM

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...

Idea Statuses