SAP-samples / data-warehouse-cloud-connectors

Connecting third party clients to SAP Data Warehouse Cloud.
Apache License 2.0
11 stars 4 forks source link

pBI does not consume business descriptions of Datasphere data products or the columns within those products #27

Closed ChristophePosson closed 3 weeks ago

ChristophePosson commented 2 months ago

Hi,

I have successfully established connection to the custom connectors and to Datasphere.

I created a very simple test data product consisting of a relational dimension view that has a technical name and a business description. 3 simple fields included, also with technical name and business description:

image image

None of the connections types I have explored immediately interpret that metadata correctly. I only get the technical names of both the view and the fields inside the view.

image

While that is the whole selling point of SAP, Datasphere keeps the business context. But once imported in pBI that context goes lost :-)

Does anyone have similar issues and more importantly, is there a solution for this?

Thanks upfront for any help in this regard, Christophe

PS: in the generated oData request on Datasphere side you do see the descriptions

image
gustavokath commented 3 weeks ago

Hi @ChristophePosson,

To give some public commenting on what we discussed via email.

I’ve investigated the Custom Connector implementation and even including more options as part of the OData.Feed on PowerBI to explicitly read metadata it does not handle the fields neither allows us to manual select the annotations included. For your reference those annotation are: IncludeAnnotations and IncludeMetadataAnnotations as described in (https://learn.microsoft.com/en-us/powerquery-m/odata-feed

Currently there will be no specific actions on this, but we are in talks we with Microsoft for better seamless integration for PowerBI.