cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

exporting underlying data to excel resulted multiple lines

Hi,

 

I have a table report which is built from 2 tables. These 2 tables have a one-to-many relationship.

When I exported the underlying data from this table to excel, it resulted multiple lines for 1 row. While the visual table shows the correct information from the combined tables.

 

What I have:

Table #1

Item NoLocation
1Location A
2Location B
3Location A
4Location C
5Location C
6Location A
7Location D


Table #2

LocationStatus
Location AOpen
Location BExpired
Location CExpired in 2018
Location DOpen

 

Table 1 & Table 2 relationship is set by the Location.

The underlying data exported is a follow

Item NoLocationStatus
1Location AOpen
1Location AExpired
1Location AExpired in 2018
2Location BOpen
2Location BExpired
2Location BExpired in 2018
3Location AOpen
3Location AExpired
3Location AExpired in 2018
4Location COpen
4Location CExpired
4Location CExpired in 2018
5Location COpen
5Location CExpired
5Location CExpired in 2018
6Location AOpen
6Location AExpired
6Location AExpired in 2018
7Location DOpen
7Location DExpired
7Location DExpired in 2018

 

Is there any thing I missed out that caused this data multiple exported?

 

7 REPLIES 7
Highlighted
Microsoft
Microsoft

@RMV,

Could you please post a screenshot about how you create the table report? I am not able to reproduce your issue.


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted

Hi @v-yuezhe-msft,

Not sure I can attach a picture. Hope this works

 

table

Highlighted

engine_table.jpg

Highlighted

@RMV,

Please show that how you create visual using the sample data you post, there is an example for your reference.
1.JPG

Regards,

Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted

Hi @v-yuezhe-msft,

 

Here's the screenshot

1. Table #1: engine status

engine.jpg

 

2. Table #2: contract

contract.jpg

 

 

3. Relationship between engine status & contract (many-to-one)

relationship.jpg

 

Highlighted

@RMV,

Would you mind sharing the data of tables in your PBIX file? I make a test using the sample data you post but can't reproduce your issue. Are you able to get same issue when using the sample data? And do you use the "Export data" option in Power BI Desktop or Power BI Service?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted

Hi @v-yuezhe-msft,

 

I'm sorry, I cannot provide the data due to my company's policy.

I tried to create dummy data to reproduce the error using it. But, I cannot reproduce the error as well.

I cannot find the pattern that might caused the error either.

In the actual data, the location that is available in Table #1 may not be available all in Table #2, and vice versa.

But, this condition works fine using dummy data.

Is there anything that might caused the data duplicated, that I need to look further?

 

Thanks

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors