Column missing error while changing data source from dev to qa

[PowerBITesting]

Got column name missing error. I deleted the column from my data tables and published again. But when I changed the data source in service that showing same error . Column is missing.

Any help?

[v-lili6-msft]

hi  @PowerBITesting 

This is a common issue, you could refer to this similar post:

https://community.powerbi.com/t5/Desktop/PowerBI-Refresh-Column-Missing/td-p/1077432

Please check it in power query and adjust the error by steps.

Regards,

Lin

[amitchandak]

@PowerBITesting , in case column is deleted at source. Then open data transformation mode/edit query

and right-click on table and open advance editor. Find the column and remove that from the source script. and then try

[Pragati11]

HI @PowerBITesting ,

You need to share additonal information here like screesnshots.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Is you report in POwer BI Service has got some refresh set-up ? Is it by a gateway?

What kind of datasource you are using for your report?

Thanks,

Pragati