How to change source connector in Power Query

Power Query Change Connector

Things change, and life moves on. Therefore, as organizational IT systems evolve, the Power Query solution you built previously might no longer use the right connector. Common examples are local Excel workbooks now stored on SharePoint, or SQL databases replacing CSV files. Previously, we looked at changing the location of the source data, but for … Read more

How to use Excel Table within a data validation list (4 easy ways)

Excel Tables expand automatically whenever new data is added. This feature alone makes Tables one of the most powerful tools within the Excel user’s toolkit. A Table can be used as the source data for a chart and within a named range, both of which benefit from the auto-expand feature. Data validation lists would also benefit … Read more