Description:
SQL Server has a database as follows:
*- number of tables: 3-5 pcs. tables
*- the number of fields in each table: - 20-50 pcs. fields;
*- the number of entries in each table: 10,000 - 50,000 pcs. records.
The data in SQL Server tables is constantly updated.
Goal:
Connect Excel to SQL Server.
Display connected tables in tables or pivot tables.
Build multiple diagrams based on connected tables or pivot tables.
By clicking the "Refresh" button to constantly receive relevant data.
Preliminary decision:
To connect, it is supposed to use Data -> Get Data -> From SQL Server Data.
Question
Would it be sufficient to use the connection method Data for such purposes -> Get data -> From SQL Server data, or do I need to use Power Query / Pivot in addition?
Bookmarks