PowerBI OData doesn't allow me to remove column

Lmaher · ‎12-15-2023

I have a query pulling data from a platform using "########-sb2.pvcloud.com/odataservice/odataservice.svc/" (## is to hide the client name)

I connect using a token .. everythig goes well and I was able to see the data and use it in visuals.

But if I try to qremove a column, I get the error "DataSource.NotFound: OData: Request failed (404): The remote server returned an error: (404) Not Found. (Not Found)"

What could be the reason for that?

v-cgao-msft · ‎12-20-2023

Hi @Lmaher ,

The error message you're encountering typically indicates that Power BI is unable to locate the resource you're trying to access. This can happen if the column you're trying to remove does not exist or if there's an issue with the OData service endpoint.

1. Ensure that the OData service endpoint URL is correct and accessible. You can test the URL in a web browser or using a tool like Postman to make sure that the service is up and running.
2. Double-check that the column you are trying to remove actually exists in the data source. If the column has been renamed or removed from the OData service, Power BI might not be able to find it.
3. Try refreshing the data model in Power BI to ensure that it has the latest schema from the OData service.
4. Remove the Column Using Power Query Editor. As a test, try removing a different column to see if the issue is specific to the column in question.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group