Forum Discussion

rgarthoff's avatar
rgarthoff
Regular Visitor
7 years ago
Solved

edit Files tables

Hi i have a question. 

Editing Source Tables Extending Columns: How to make sure that the source file still works after expanding it by one column of content? or works again and no error message arises?

 

now if i edit the excelfile with new columns i get a failure. "

The key does not correspond to any row in the table

" Is it possible to change the key?

 

Thank you 

 

  • Anonymous's avatar
    Anonymous
    7 years ago

    rgarthoff,

    Could you please describe more details about what changes you make in the excel file and share the original excel file here?

    In Power BI Desktop query editor, you can click on each step under "APPLIED STEPS" and then check which step throws error message after you make changes in excel file.


    Regards,
    Lydia

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    rgarthoff,

    Could you please describe more details about what changes you make in the excel file and share the original excel file here?

    In Power BI Desktop query editor, you can click on each step under "APPLIED STEPS" and then check which step throws error message after you make changes in excel file.


    Regards,
    Lydia