This guide discusses combining tables from the same workbook only, not external sources or multiple workbooks. Make sure all the datasets you want to append are formatted as Excel ...

Keep your dashboards and reports up to date by connecting to your on-premises data ... deploy multiple on-premises data connections across Power BI, Power Apps, Power Automate, and Azure Logic Apps ...