locked
column table source changed: problems! RRS feed

  • Question

  • Hi,

    I've got a powerbi working with a range of excel tables. One of them has a changed columnname:

    was: Nr.:

    is: Nr

    When refreshing the source, it keeps asking 'Nr.:', even though I've changed all names in the relations (first attempt) and removed the table and added it completely new.

    Can anybody help me?

    Thanks!

    Sunday, May 7, 2017 10:18 AM

Answers

  • Probably you have 1 or more queries referring to "Nr.:".

    In order to provide more specific help, more specific information is required, like:

    • Are you importing Excel files from a folder or each file individually?
    • Are you combining the Excel files into 1 table?
    • Do you have a mix of "Nr.:" and "Nr" now?

    Maybe you can share some code and/or (fake) data?

    Sunday, May 7, 2017 10:52 AM

All replies

  • Probably you have 1 or more queries referring to "Nr.:".

    In order to provide more specific help, more specific information is required, like:

    • Are you importing Excel files from a folder or each file individually?
    • Are you combining the Excel files into 1 table?
    • Do you have a mix of "Nr.:" and "Nr" now?

    Maybe you can share some code and/or (fake) data?

    Sunday, May 7, 2017 10:52 AM
  • Thanks for reacting. With your answer i've put more energy in searching the queries. Finally found it; stupid I did'nt see it before! Thanks!!

    Sunday, May 7, 2017 7:31 PM