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
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi BigAky74 
I see a space-symbol at first screenshot between "sales" and "curr" - "sales curr"
and there is no space at the second "salescurr"

I think you should find issue somwhere in column name

  • 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?