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: