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 (see screenshot below). I never did any change to the model, I've only updated to last PBI version in february.

 

Can you please help?

 

Thanks 

 

Achille

 

 

 

 

column existing in dataseterror message

Need Help

10 Replies

  • az38's avatar
    az38
    Community 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
      Helper 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