We can use XML data to populate our dashboard with data. To do this, we first need to display the Developer tab in Excel. This is because we will call the XML URL from the Excel Developer tab.
Go to the Excel options and show the Developer tab, as marked in the following screenshot:
Now, let's follow the steps to establish an XML connection: