Forum Discussion

amyWMFS's avatar
amyWMFS
Icon for Helper I rankHelper I
6 years ago

Column does not exist in the rowset, Desktop only

Hi,  One of my reports has just started getting a strange issue: when I refresh the date in Desktop, I get an error message that a particular column does not exist in the rowset. But it does exist, ...
Need Help
amyWMFS's avatar
amyWMFS
Icon for Helper I rankHelper I
6 years ago

yes, same here, it was working fine until I upgraded to the March version.

As we don't know exactly what's gone wrong, I can't really say whether it's something only MS can fix, but it does seem like it. So far they seem stumped by this error. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

So it is definitely the in line (Alt + Enter) that is causing the issue as I went and removed these in the source (excel) the copied this into Power BI and it worked fine.

 

The problem is there are a few models that have this in line problem and to change these is going to be additional work 😞

 

The models was built about 4 to 6 weeks ago (the one last year) and worked fine with the in line and since the latest updates it does not like it anymore. Hoping Microsoft fixes this bug soon.