Forum Discussion

RMV's avatar
RMV
Icon for Helper V rankHelper V
9 years ago

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 f...
Need Help
RMV's avatar
RMV
Icon for Helper V rankHelper V
9 years ago

Hi Anonymous,

Not sure I can attach a picture. Hope this works

 

table

Anonymous's avatar
Anonymous
Not applicable
9 years ago

RMV,

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


Regards,

Lydia

  • RMV's avatar
    RMV
    Icon for Helper V rankHelper V
    9 years ago

    Hi Anonymous,

     

    Here's the screenshot

    1. Table #1: engine status

     

    2. Table #2: contract

     

     

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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

      • RMV's avatar
        RMV
        Icon for Helper V rankHelper V
        8 years ago

        Hi Anonymous,

         

        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