Power BI Question

[ms166]

When uploading files to a Power BI report from a folder, is it possible to programme the automatic removal of certain colunms and rows or does this have to be done manually everytime?

[SamWiseOwl · Accepted solution]

Hi @ms166 

When you connect to the folder and choose transform all the files are listed like so:

You can choose which columns and files to include before click on the expand icon next to Content.

Once expanded you can remove columns and filter rows in the combined table.

These will be added as applied steps and will be reapplied to the combined query.

Any files that have been added since the last refresh will also be included.

Hope this helps!

[Kedar_Pande · Accepted solution]

Yes, you can automate the removal of specific columns and rows when uploading files from a folder in Power BI by using Power Query.

1. In Power Query, after loading the data, you can select the columns you want to keep.
   Right-click on the unwanted columns and choose Remove.
2. Right-click on the rows/values you want to filter out and select Remove Rows or apply a conditional filter in the filter options for that column.
3. Once you've set the transformations (removing columns/rows), click on Close & Load.

If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[SamWiseOwl · Accepted solution]

Hi @ms166 

When you connect to the folder and choose transform all the files are listed like so:

You can choose which columns and files to include before click on the expand icon next to Content.

Once expanded you can remove columns and filter rows in the combined table.

These will be added as applied steps and will be reapplied to the combined query.

Any files that have been added since the last refresh will also be included.

Hope this helps!