SQLWATCH 4.3 - Power BI Report failing to run against Central Database, Grafana works fine.

[monteroman]

Did you check DOCS to make sure there is no workaround? I went through the documentation and am using SQLWatchImport.exe to run the imports and to do the central repo instance setup.

Describe the bug The Power BI report was working fine against a single server instance, but when I ran SQLWATCHIMPORT to add a second instance, the report fails with these errors:

Dim Server Load was cancelled by an error in loading a previous table. Dim Environment Load was cancelled by an error in loading a previous table. Dim Database Column 'database_name' in Table 'Dim Database' contains a duplicate value 'master' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. Dim Master File Load was cancelled by an error in loading a previous table. Dim Table OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred. Dim Index Load was cancelled by an error in loading a previous table. Wait Statistics Load was cancelled by an error in loading a previous table. Performance Counters OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred. Performance Counters Analyser Current OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred. Performance Counters Analyser Baseline 1 OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred. Performance Counters Analyser Baseline 2 Load was cancelled by an error in loading a previous table. Performance Counters Analyser Baseline 3 OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred. Process Memory Load was cancelled by an error in loading a previous table. Memory Clerks OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred. File Statistics Load was cancelled by an error in loading a previous table. Schedulers OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred. XE IO Subsystem Load was cancelled by an error in loading a previous table. XE Query Processing Load was cancelled by an error in loading a previous table. XE Query Waits OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred. Blockers OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred. WhoIsActive OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred. File Statistics Sankey File to Disk OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred. Missing Index Stats Load was cancelled by an error in loading a previous table. Index Statistics Load was cancelled by an error in loading a previous table. Index Histogram Load was cancelled by an error in loading a previous table. Disk Utilisation DB Load was cancelled by an error in loading a previous table. Disk Utilisation OS OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred. Dim Time Server Load was cancelled by an error in loading a previous table. Dim Agent Jobs Load was cancelled by an error in loading a previous table. Dim Agent Job Steps OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred. Disk Utilisation Table Load was cancelled by an error in loading a previous table. Agent History Load was cancelled by an error in loading a previous table. Dim OS Volume Load was cancelled by an error in loading a previous table. fn_get_end_time OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. Dim Missing Index OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred. File Statistics Sankey Database to File Load was cancelled by an error in loading a previous table. fn_get_aggregation_source OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. Dim Check Load was cancelled by an error in loading a previous table. Checks OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred. Dim Perf Counter Instance Load was cancelled by an error in loading a previous table. fn_get_baseline Load was cancelled by an error in loading a previous table. Dim Time OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred. fn_get_end_time_baseline_1 OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. fn_get_end_time_baseline_2 OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. fn_get_end_time_baseline_3 Load was cancelled by an error in loading a previous table.

To Reproduce Steps to reproduce the behavior:

1. On server 1 Set up SQLWatch from scratch by installing the dacpac
2. On server 2 Set up SQLWatch on another server from the dacpac
3. From server 1 which also has Power BI installed and configured, load the pbix file "20210430" and adjust the datasource data and password and run. Since it's pointing to server 1 and no other instance has been added, the report runs.
4. From server 1, run sqlwatchimport --add -s server2 -d sqlwatch
5. Validate that the server2 entries are in the dbo.sqlwatch_config_sql_instance table.
6. Refresh the pbix file ending in 20210430 and the error comes up.

Expected behavior I would expect the report to process and show me the SQL instances

Screenshots If applicable, add screenshots to help explain your problem.

Windows Server (please complete the following information):

• OS Version: Windows 2022 Std

SQL Server (please complete the following information):

• SQL Version: 2019 w/cu16
• SQL Edition: Standard

SQL Server Management Studio (SSMS -> about -> copy info):

• paste "about" info here: SQL Server Management Studio 15.0.18424.0 SQL Server Management Objects (SMO) 16.100.47021.0+7eef34a564af48c5b0cf0d617a65fd77f06c3eb1 Microsoft Analysis Services Client Tools 15.0.19750.0 Microsoft Data Access Components (MDAC) 10.0.20348.1 Microsoft MSXML 3.0 6.0 Microsoft .NET Framework 4.0.30319.42000 Operating System 10.0.20348

SQLWATCH version (from DACPAC or from sysinstances)

• 4.2.0.28234

Additional context When I run the Grafana reports, they seem to be producing the additional SQL instances from the central repository.

These are the instances I have set up for monitoring: