Forum Discussion
SammiF1244
Helper I
Helper IPeriodic 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
Community Champion
Community Championwhat's the related key between these two table?
SammiF1244Helper I
Helper Iwdx223_Daniel It is column 2 "Product_id"
Thanks
- SammiF1244
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 FilesOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.**File: OPTUM_CPT_BASE_COVERAGEOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.**File: OPTUM_HCPCS_BASE_COVERAGELoad was cancelled by an error in loading a previous table.*Appended: Optum CPT/HCPCSOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.BHAR Product_TableOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.CCHHS Product_TableLoad was cancelled by an error in loading a previous table.CMIL Product_TableOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.LWWA Product_TableOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.MABR Product_TableOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.MAMC Product_TableOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.MPMD Product_TableOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.PMAK Product_TableOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.PMWA Product_TableOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.SMNY Product_TableOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.BHAR_Optum_ProductOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.CCHHS_Optum_ProductOLE 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_ProductOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.LWWA_Optum_ProductOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.MABR_Optum_ProductOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.MAMC_Optum_ProductOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.MPMD_Optum_ProductOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.PMAK_Optum_ProductOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.PMWA_Optum_ProductOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.SMNY_Optum_ProductOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. An unexpected exception occurred.****DateStampsOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.Query parameters