BI refresh failure on service Processing error: OLE DB or ODBC error. A connection could not be made

Hi Nivedhana I think that might be the cause of the issue as some features are not there in trial trial license mostly connecting to another dataset requires a Pro or Premium Per User (PPU) license

Hi Nivedhana ,

Thank you for reaching out to the Microsoft Fabric Community.

The refresh failure is likely due to the license difference between the two workspaces. The MRMD workspace has a Pro license, while the affected workspace is using a Pro trial license, which may have limited features for cross-workspace dataset sharing. As Akash_Varuna  suggestion regarding the Pro or PPU license requirement is correct, as connecting to datasets from another workspace typically requires both workspaces to have Pro or PPU licenses.

To resolve the issue, upgrade the trial license to a full Pro license on the affected workspace and ensure both workspaces have the same license type. Additionally, verify Granular Access Control is enabled with the necessary Build permissions assigned.

For more information, refer to Power BI service features by license type - Power BI | Microsoft Learn

I hope my suggestions give you good idea, if you need any further assistance, feel free to reach out.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thank you.