SAP BW -Bex WITH POWER BI

[vishwa_molex]

When we connect power bi with Bex  : 

 it only shows the text no key value is displayed. We are using direct query connection to Bex.

Is this the limitation of PBI?

Any help /Input is appreciated.

Thanks

Vishwanath

[v-lili6-msft]

hi, @vishwa_molex 

It seems that there is no limitation for it.

SAP BW display Key and Text
It seems as if only Text is available to select.
We require the Key to be available to build relationships and to view data

This feature was released in the Power BI Desktop October update. Please take a look at the official release announcement for more details: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-2017-feature-summary/#sapBW

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16376959-sap-bw-display-key-and-t...

Best Regards,

Lin

[vishwa_molex]

No, It did not help me. I do not have a solution for me.

Can you get the update from product team ?

[v-lili6-msft]

hi, @vishwa_molex 

If you only have this issue for Power BI, I would suggest you create a support ticket in Power BI Support to get further help.

How to create a support ticket in Power BI

Once you submit the ticket, you will get an email from support@mail.support.microsoft.com. Someone from the  Microsoft support team will contact you.

Best Regards,

Lin

[vishwa_molex]

Can you confirm if this is available when we connect Bex query with directi connection mode ?

Thanks

[v-lili6-msft]

hi, @vishwa_molex 

Sorry, I have no SAP BW for test, and i don't find any documents about this limitation.

You could do a test on yourself. If you change the directquery to Import in your side, does it work well? 

Best Regards,

Lin

[vishwa_molex]

yes,

I ahve tested this with direct query and thats the reason it was posted in idea page.

Thanks