Error persistente en Power BI No se encuentra la columna drive después de eliminarla del modelo

[Fernando232]

Hola, 
Tengo una columna en Excel que refleja la fecha actual. Use esa tabla para crear un reporte en power bi y realmente esa columna no me sirve, al momento de transformar los datos elimine todas las columnas y deje unicamente las que necesitaba pero al dia siguiente la columna en drive se actualiza a la fecha actual y me dejo ese error en mi reporte. 

[Anonymous · Accepted solution]

Hi @Fernando232 ,

From what I understand, you have a column in Excel that updates daily and， although you removed this column when transforming the data into Power BI， the automatic update of the column in the Excel file on your drive is causing errors in your Power BI report.

Please follow these steps:

Make sure that Power BI is not trying to import the deleted column when the Excel file is refreshed.

If your Excel file is stored in OneDrive or SharePoint, Power BI will refresh it approximately every hour. Make sure you make any changes to your Excel file, such as deleting unwanted columns, before the automatic refresh.

I have also found similar posts, please refer to.

Solved: Re: Removing any columns causes errors - Microsoft Fabric Community

• cleared my cache - went to "data source settings" and cleared all permissions - then recaptured them.

Solved: Expression.Error: "The column of the table wasn't ... - Microsoft Fabric Community

• You can edit the query steps or re-examine the source and see where the problem is .

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fernando232]