Forum Discussion
Periodic data comparison between TABLE 1 'industry standard' and TABLE 2 'Client specific software'
I work in software, and with my current company, it's a very manual process in many ways. I came from API driven updates so, I am shocked and in need to create an easy, automated way to check for new...
wdx223_Daniel It is column 2 "Product_id"
Thanks
I did figure out that I didn't have all my relationhsip connect in the data model. So, now, it is working well 🙂
I'd shre the code, but there are 22 tables worth and I am unsure hw to get the entire PBI file code at once --if it is possible.
One issue though, today, I added a 'date list' to it so that I could better manage dates, and when I tried to save it, it is showing this 'refresh' status error pasted below. All query are showing data with no error in transform view, but will not refresh 😞
Refresh
***Folder: Source Files
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
**File: OPTUM_CPT_BASE_COVERAGE
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
**File: OPTUM_HCPCS_BASE_COVERAGE
Load was cancelled by an error in loading a previous table.
*Appended: Optum CPT/HCPCS
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
BHAR Product_Table
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
CCHHS Product_Table
Load was cancelled by an error in loading a previous table.
CMIL Product_Table
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
LWWA Product_Table
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
MABR Product_Table
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
MAMC Product_Table
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
MPMD Product_Table
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
PMAK Product_Table
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
PMWA Product_Table
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
SMNY Product_Table
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
BHAR_Optum_Product
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
CCHHS_Optum_Product
OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server). An unexpected exception occurred.
CMIL_Optum_Product
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
LWWA_Optum_Product
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
MABR_Optum_Product
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
MAMC_Optum_Product
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
MPMD_Optum_Product
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
PMAK_Optum_Product
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
PMWA_Optum_Product
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
SMNY_Optum_Product
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.
****DateStamps
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
Query parameters