- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 No | Location |
1 | Location A |
2 | Location B |
3 | Location A |
4 | Location C |
5 | Location C |
6 | Location A |
7 | Location D |
Table #2
Location | Status |
Location A | Open |
Location B | Expired |
Location C | Expired in 2018 |
Location D | Open |
Table 1 & Table 2 relationship is set by the Location.
The underlying data exported is a follow
Item No | Location | Status |
1 | Location A | Open |
1 | Location A | Expired |
1 | Location A | Expired in 2018 |
2 | Location B | Open |
2 | Location B | Expired |
2 | Location B | Expired in 2018 |
3 | Location A | Open |
3 | Location A | Expired |
3 | Location A | Expired in 2018 |
4 | Location C | Open |
4 | Location C | Expired |
4 | Location C | Expired in 2018 |
5 | Location C | Open |
5 | Location C | Expired |
5 | Location C | Expired in 2018 |
6 | Location A | Open |
6 | Location A | Expired |
6 | Location A | Expired in 2018 |
7 | Location D | Open |
7 | Location D | Expired |
7 | Location D | Expired in 2018 |
Is there any thing I missed out that caused this data multiple exported?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@RMV,
Could you please post a screenshot about how you create the table report? I am not able to reproduce your issue.
Regards,
Lydia
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@RMV,
Please show that how you create visual using the sample data you post, there is an example for your reference.
Regards,
Lydia
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @v-yuezhe-msft,
Here's the screenshot
1. Table #1: engine status
2. Table #2: contract
3. Relationship between engine status & contract (many-to-one)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
User | Count |
---|---|
55 | |
54 | |
49 | |
13 | |
13 |