Forum Discussion

BigAky74's avatar
BigAky74
Helper 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
mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi BigAky74 ,

 

did anyone change the column names in Excel?

 

BigAky74's avatar
BigAky74
Helper 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
    Most Valuable Professional
    6 years ago

    Hi BigAky74 ,

     

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

     

    • BigAky74's avatar
      BigAky74
      Helper 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!!!

      • v-deddai1-msft's avatar
        v-deddai1-msft
        Community Support
        6 years ago

        Hi BigAky74 ,

         

        This seems to be an issue during data transforming. I suggest you show  the applied steps or advanced editor for the query.

         

        Best Regards,

        Dedmon Dai