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

Hi AZ38

 

thanks for your feedback.
I tried your tip but no way: it does not work.

I did some deeper check: dataset is correctly uploaded and trasformed (it's an excel source) in PBI:

1)If I dont' change the column name you saw the result (column figures are all "zero").

2) if I change the name to macth it with dataset following what happens: all values disappear

 

Let me know if you have another solution.

 

Thanks

 

Achille

 

no values

 

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)