Forum Discussion
C_Bricker
10 years agoNew Member
Get key instead of text from SAP BW Cube
Hi All. I'm using PBI to get data from SAP BW InfoCubes. In my cubes, most characteristics have both a key value and a text value. When I bring the data into PBI, only the text value is importe...
GuyInACube
Administrator
10 years agoI'm not overly familiar with SAP BW, but this sounds similar to a limitation we have on the SSAS side with member properties.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12443955-member-properties-ssas
Doesn't really answer the question though :(
- jansb00010 years agoRegular Visitor
This means that we can not combine SAP BW data with data from other sources. Relations between tables are always made with ID fields. This is really a big problem for us.
- Blombak10 years agoRegular Visitor
Also stuck with this problem. Anyone know of a work around ?
- vrossouw10 years ago
Helper III
Power BI developers, we need the SAP BW Key to be available please. Is it possible to include the fix in the next Upgrade?
We can't use SAP BW at all at this point, because we need the Key to be available.