Dynamic references

Power Query dynamic Excel worksheet name

Purpose: use a dynamic Excel worksheet name for a Power Query or Power BI data source When linking to data in another Excel workbook, you may want to update the worksheet name containing your data source, without having to update the Power Query steps. Here’s how to create a dynamic Excel workbook sheet reference for a Power Query data source. Links to sections on this page Overview of steps Store