Forum Discussion

Burma's avatar
Burma
Helper I
6 years ago
Solved

New bug: The column does not exist in the rowset.

Hi, recently I've started getting an error in Power BI Service, which does not happen in Power BI Desktop   I'm getting "column does not exist in the rowset" error when refreshing a published datas...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Burma ,

     

    For the issue, I cannot reproduce it here. We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/

     

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

csabil's avatar
csabil
Advocate II
6 years ago

Any update on this issue? 

 

It started happening to me yesterday after updating on of the source files (excel on SharePoint). It's looking for "Column70" which doesn't exist and not referenced anywhere in the query either.

 

When you say you solved removing the lf from the column name, which column? It's looking for one which doesn't exist...

 

Thanks for the help

Burma's avatar
Burma
Helper I
6 years ago

It also refreshes fine in the desktop app but fails in the web app?

 

The original issue seems to happen with SharePoint lists, but not Excel files