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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

BigAky74 , do not change the column name. Drag this column again in visual and formula

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?