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?

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