cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
carlbh Regular Visitor
Regular Visitor

I need to delete some columns in my data source Excel tables and not impact my existing PBI reports

 I am currently using exported data from a Case management system put into Excel tables stored in Sharepoint as my data sources.

We are moving to a new case management system which has a restriction on the number of columns I can export to Excel. As such so that I can more easily align the old and new data,  I am looking to find a way to be able to delete surplus columns from my existing data source, without having to rebuild the whole data query for each table that makes up the report.

I am using the same source Excel tables for multiple reports, so the simpler the solution for me the better.

Previous answers on here have advised to delete the column in Power Query editor, but all my queries import the whole table not specific columns. There are no references to the specific columns I am looking to remove in Power Query.

WHen I try to reload the new table it deletes all subsequent steps in the query.

Put simply I want to be able to delete columns from source data and then do the same in my imported query table so that they match and dont produce errors.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: I need to delete some columns in my data source Excel tables and not impact my existing PBI repo

Hi @carlbh ,

 

You can change the current source URL to your deleted columns data source URL in Query Editor, for example the following picture. After click "Close & Apply", maybe you need to correct the visuals in report which contain your deleted columns.

 

3.png

Best Regards,

Amy

 

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

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: I need to delete some columns in my data source Excel tables and not impact my existing PBI repo

Hi @carlbh ,

 

You can change the current source URL to your deleted columns data source URL in Query Editor, for example the following picture. After click "Close & Apply", maybe you need to correct the visuals in report which contain your deleted columns.

 

3.png

Best Regards,

Amy

 

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

View solution in original post

Community Support Team
Community Support Team

Re: I need to delete some columns in my data source Excel tables and not impact my existing PBI repo

Hi  @carlbh  ,

 

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors