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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

RMV,

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


Regards,
Lydia

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

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

  • 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