Modifying source table structure

[Loay_Haggag]

Hi All,

While loading Data from Excel, i need to remove some columns & rows as a kind of cleaning or formating.

Is there a way to perform this automatically with Power BI instead of using another tool (ex. VBA Macro)?

Thanks,

Loay Haggag

[Anonymous]

Hey @Loay_Haggag 

Any of the steps done in the query editor in desktop will be done automaticalll with each refresh.

You can remove columns and rows in the query editor. Rows are a little more complicated unless you are simply trying to remove duplicates or filter out certain values in certain column. Any filtering done in query editor will be applied to the data that can be used in report creation.

Check out this link for more info: https://docs.microsoft.com/en-us/power-bi/desktop-query-overview

If this helps please kudo.

If this solves your problem please accpet it as a solution.