Forum Discussion
Install update error, desktop updates correctly
Hi Syndicate_Admin,
Thank you for reaching out to the Microsoft Fabric Forum Community.
The recent update to the 64-bit Oracle Client 19c (version 19.27) is likely the cause of the increasing column-related errors during scheduled refreshes in Power BI Service. The newer driver may handle metadata exposure differently, causing the gateway to fail to detect certain columns that Power BI Desktop still recognizes due to cached data. Since the gateway relies on the Oracle client for data access, any issues with the driver can directly impact refresh functionality. To resolve this, you can either roll back to the previous Oracle client version that worked reliably or try reinstalling the current version to fix any configuration issues.
If the issue still persists, I’d recommend raising a support ticket with Microsoft. The support team can look into the backend and provide more in-depth assistance tailored to your environment.
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticketIf this solution helped, please consider marking the response as accepted and giving it a thumbs-up so others can benefit as well.
Best regards,
Prasanna Kumar
Hi Syndicate_Admin,
Thank you for reaching out to the Microsoft Fabric Forum Community.
The error occurs because the DATOS_INTERLOCUTORES column is not always available or recognized during the refresh in Power BI Service, even though it works fine in Desktop. This is likely due to schema drift or inconsistencies in the source view. To resolve this, you should explicitly check if the column exists using Table.ColumnNames before performing any transformations. Wrapping your logic in a conditional check ensures that the column is only processed if present, preventing the gateway from failing. Additionally, avoid relying on dynamically changing views by creating a stable version with a fixed schema, and use Table.SelectColumns to define the expected structure clearly.
If this solution helped, please consider marking the response as accepted and giving it a thumbs-up so others can benefit as well.
Best regards,
Prasanna Kumar
The problem is getting worse, as more reports begin to give this problem, each with a different column.
Just yesterday I updated the Oracle connector for this:64-bit Oracle Client for Microsoft Tools 19c (version 19.27)
Since he told me that the one I had was obsolete. Could it be the problem?
