Refreshing a Spreadsheet broke the Formatting Rules and columns that were rearranged

[Syndicate_Admin]

I'm new to Power Query and have a few questions on what I can and can't do.

I have a spreadsheet that was sent to me and the data is based on a power query.

• I performed the following steps on the workbook
• added an additional sheet with a lookup table
• added some columns where the calculations dealt with workdays and networkdays where the days for the workdays was
• located in the lookup table in the other sheet
• moved some columns around in the spreadsheet
• added some Conditional Formatting Rules

I then sent the spreadsheet back to the owner of the sheet.  Upon refresh the spreadsheet broke.  The Rules somehow changed what rows they applied to and columns appeared rearranged

Do all the steps mentioned above need to be performed in Power Query?

Can all the steps be performed using Power Query?

If the answer is "Yes", can you give some insight on performing the steps above in Power Query.

Thanks!

[lbendlin]

Power Query cannot do any of the UI manipulations (like editing sheet content/format). It can only manipulate the data and eventually return a table.

You may want to separate the ETL (acquiring and shaping the raw data) from the Visualization (sheets and pivots/charts etc. by feeding your Power Query results into a "raw" sheet that users won't need to touch.