Forum Discussion

BigAky74's avatar
BigAky74
Icon for Helper I rankHelper I
6 years ago

Data connetiction troubles

  Hello   I have trouble with a report that I've been using since one year. When I refresh data, I have an error message saying "column does not exist in the rowset" while the column is present (...
Need Help
BigAky74's avatar
BigAky74
Icon for Helper I rankHelper I
6 years ago

Sorry

 

I don't understand: you mean moving from "power query editor" where the column exists? If yes, how can I do that?

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi BigAky74 ,

 

did anyone change the column names in Excel?

 

  • BigAky74's avatar
    BigAky74
    Icon for Helper I rankHelper I
    6 years ago

    Hello

     

    no, name is still the same.

    I did some test, following results:

    1) column is correctly uploaded on Power Query with all values (see screenshot)

     

    2) something happens in deskotp as column exists but values are then missing (see screenshot)

    • mwegener's avatar
      mwegener
      Icon for Most Valuable Professional rankMost Valuable Professional
      6 years ago

      Hi BigAky74 ,

       

      can you give a look at the following power query steps?

       

      • BigAky74's avatar
        BigAky74
        Icon for Helper I rankHelper I
        6 years ago

        Hello Dedmon

         

        I tried suggested solution but it does not work: same error message still...

         

        Do you have another solution?

         

        Thanks

         

        Achille

         

        PS: Happy Easter!!!