Excel 2016 has built in BI capabilities. To get data from an external data source, go to the Data tab:
Under Get and Transform, select New Query:
We will get data from a local SQL database:
Enter the database details:
Select a table and click Edit:
This opens the Query Editor:
Click the Advanced Editor to see the connection details:
Click OK to close the Query Editor. The data is loaded to the spreadsheet. Select Manage Data Model:
To add to the data model, go to the Power Pivot tab and select Add to Data Model:
Keep learning. Keep building.
Explore AI, agents & Microsoft technology.
I share practical ideas, tutorials, and videos about AI, AI agents, Microsoft technologies, and the Power Platform.
Subscribe on YouTube →Carl de Souza Enterprise Architect at Microsoft · AI Technology Expert