Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Lmaher
New Member

PowerBI OData doesn't allow me to remove column

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?

1 REPLY 1
v-cgao-msft
Community Support
Community Support

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

Helpful resources

Announcements
Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors