Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Pascal_KTeam
Resolver I
Resolver I

Data from SAP BW open ODS view not correct - (Cartesian product)

Hi all

I have a BEx Query which is based on an open ODS view in SAP BW. (What is an open ODS view: https://help.sap.com/doc/saphelp_nw74/7.4.16/en-US/3c/2501f075cb42b1aef74b6b4e5fa9de/content.htm?no_...)

 

I use Power BI to load this data via import mode. Unfortunately, the data I get is the Cartesian product so it can't be used.

 

The data in BW looks like this:

 

CountryUser
SwitzerlandUser 1
GermanyUser 2

 

But the data I see in Power BI looks like this:

 

CountryUser
SwitzerlandUser 1
SwitzerlandUser 2
GermanyUser 1
GermanyUser 2

 

So I wonder if anybody has experience with loading data from a BW Open DSO View. Is this even supported by Power BI?

1 ACCEPTED SOLUTION
Pascal_KTeam
Resolver I
Resolver I

Solved: once a key figure is added to the open ODS view in BW, it works fine

View solution in original post

3 REPLIES 3
Adrian1989
New Member

Use LibreOffice or OpenODS, and you will be able to open it correctly. Hope that helps you 😉

Pascal_KTeam
Resolver I
Resolver I

Solved: once a key figure is added to the open ODS view in BW, it works fine
v-frfei-msft
Community Support
Community Support

Hi @Pascal_KTeam ,

 

To be honest, I have no expericen with that. I have done some research for that, Hope the third - party article can help you.

https://businessintelligist.com/2017/04/11/power-bi-and-sap-what-works-and-what-doesnt/

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors