Premium (Service?) Only Error

[Anonymous]

I have got a Power BI Desktop file in a Sharepoint folder linked to a Premium (Service?) sheet at App.PowerBi. When I refresh with the updated survey data in this file I get no errors in the Desktop version. But when I manually pressed to refresh in the online presentation at App.PowerBi I got a series of confusing errors. Always the error says the same column is missing from various tables, whether it makes sense for the table to require that column from the Source or not. Finally after adding the column to every table with that Source, it says the column is missing from a table that it is already in! Anyone experienced this before? I have checked I have the February 2022 update of PowerBI and that I have this new Microsoft Edge WebView2 Runtime program installed, per a warning message from the Desktop app. 

Here is the text of the final error, which looks like all subsequent errors except for the fact I can't move on to a different table error by altering it, because I don't feel I can add what is already there !

"

Expression.Error: The column '<pii>Years of experience in your current professional setting:</pii>' of the table wasn't found.. <pii>Years of experience in your current professional setting:</pii>. . The exception was raised by the IDbCommand interface. Table: Respondent Info.

"

[nitishsh91]

Hi @Anonymous 

Please can you check if in your step somewhere this column name is being mentioned?
Also is there any step in which you are removing any column from your dataset?

This usually happens when you ae removing any column from the data and that name is mentioned somewhere , if that's the case use Remove Other Columns and that should help.

[Anonymous]

Thanks for the reply nitishsh. It does remove some columns! The first step after the Source is a 'Removed other Columns' step using

"

Table.SelectColumns(Source, {"..... *several other columns*...","MY COLUMN"}).

"

"My Column" has got a long name that is a raw prompt in an online survey: "Years of experience..." The data is in a CSV where the different prompts are column subheadings. In the table in question the column is not mentioned by name in any subsequent step. (I see I used 'subsequent errors' in my question when I should have said 'preceding errors.') 

[nitishsh91]

Please try to remove dependency on column names and it should work fine on gateway too. 

[Anonymous]

Do you mean find a way to prepare the table without referring directly to the textual names of the columns, or just that column? Such as by positions instead of names? It could make it harder to maintain through additions to the survey of new columns and prompts but my first pripority is figuring out how to publish the update. Everything correct on the Desktop app and it updates the visuals with new data just fine, but Premium refuses. And by gateway I guess you mean Premium/Service, the sheet viewable online at app.powerbi? 

[nitishsh91]

Yes that's right.

Please have a look at this link : https://community.powerbi.com/t5/Desktop/Renaming-Columns-by-Column-Number/m-p/159241

Ignore the gateway bit, I thought you were using gateway but it doesn't need any gateway as it can connect directly.