Forum Discussion

amyWMFS's avatar
amyWMFS
Helper 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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous Hi mate, I'm getting the same error as below whereas nothing has changed in this file nor the column removed.

 I have tried all the below:

1. Checked to confirm nothing is changed with the source Excel (.xlsx) file.

2. Location of the Excel file is the same.

3. Refreshed each and every query, individually in Power Query.

4. Changed location of both PBIX and Excel source files from SharePoint Online Site to local computer Documents folder.

5. Changed the name of the Excel source file (sounds silly) but tried it too.

6. Updated my current Power BI Desktop version from 2.79.5768.921 to 2.79.5768.1082.

The issue still persists!

However, I did not understand the concept of "line feed" on Alt + Enter in source Excel file.

Can anyone explain with screenshots so I can try this option?

If if you have found the resolution/fix to this issue by means of your already raising a ticket with Microsoft Power BI team about this, then please share the solution/fix.

Thanks in advance.

Chandu

amyWMFS's avatar
amyWMFS
Helper I
6 years ago

Hi Chandu,

 

when you're in an excel cell and you want to start a new line within the same cell, you use Alt+Enter. My headers have those in (I didn't make the headers...).

From your screenshots your header doesn't seem to have one of those in. Maybe it's the '/', have you tried removing it?

 

I have a ticket with PBI, but it's on hld at the moment due to already large workload at this time of year plus the extra workload created by the current pandemic situation. I hope to re-open it in the next week or so.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amyWMFS Oh ok, sorry.. I knew that Alt + Enter. I got confused with the word "Line Feed". You are absolutely right.. in my case, "Injury/" was in the first line and "Space+Illness" was in the second line (again, it was not me who did this header, I've taken over someone else's report and spready!).

    As you suggested, I changed the column to read as "Injury or Illness" and my report is working perfectly fine now.

    Thank you so much for you help mate. Greatly appreciated.

    Regards,

    Chandu