cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
TimVe

After upgrade Odata functions are missing in connector

Submitted by 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
See more ideas labeled with:
9 Comments (9 New)
Comments
TimVe
New Member
‎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/

 

v-qiuyu-msft
Community Support
Community Support
‎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 

Vicky_Song
Impactful Individual
Impactful Individual
‎07-04-2018 12:40 AM
Status changed to: Accepted
 
ergore
Regular Visitor
‎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"'.

TimVe
New Member
‎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.

widget73
Regular Visitor
‎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/

vco
Regular Visitor
‎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...

widget73
Regular Visitor
‎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  

vco
Regular Visitor
‎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