OLE DB or ODBC Error Failed to retrieve data

[Deeksham]

Hi all,

I'm getting the following error when i refresh the dashboard whereas my colleague who took over the data source from my dashboard was able to refresh the dashboard fine.

Is it a network issue, can this be solved so that i can take over the dashboard?

Thanks in advance

[Deeksham]

Hi Sahasra,

ALL GL ACCTS data source is refreshed on other dashboards except for one, i have tried to duplicate the dashboard which i'm trying and refresh worked fine for the duplicate dashboard. I'm not sure why is it happening only to the particular one.

[v-sgandrathi · Accepted solution]

Hi  @Deeksham,

If you still face the issue then please consider raising a support ticket for further assistance.

To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thankyou.

[v-sgandrathi]

Hi @Deeksham,

We are following up regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If resolved, kindly share the resolution or key insights here to assist others in the community. If we don’t hear back, we will close this thread.

For further assistance, please reach out via the Microsoft Fabric Community Forum and create a new thread. We will be happy to help.

Thank you for your understanding and participation.

[v-sgandrathi]

Hi @Deeksham,
Thanks for connecting with the Microsoft Fabric Community Forum.

 The "OLE DB or ODBC Error" typically occurs due to connectivity or configuration issues between Power BI and the data source. To resolve this, please follow the troubleshooting steps:

Ensure that your account has the same permissions as your colleagues on the data source.
check your connection settings (e.g., server name, database name, and credentials) to ensure they are correct and compare these settings with your colleagues to confirm they match.
Test your network connection to ensure it is stable. If possible, try refreshing the data on a different network.
Ensure your OLE DB or ODBC drivers are up to date if not download the latest version.

By following these steps, you should be able to resolve the error and refresh your dashboard successfully. If the issue persists or if you face any difficulties during these steps, please reach out, and we will be happy to assist further.

I’m attaching the Microsoft solved document link, If you want you can go through it for your reference.

Links:
Solved: OLE DB or ODBC error - Microsoft Fabric Community.
Solved: Re: OLE DB or ODBC error: [Data Source. Error] - Microsoft Fabric Community
Solved: Error returned: 'OLE DB or ODBC error: [Expression... - Microsoft Fabric Community

Please Accept as solution if this meets your needs and a Kudos would be appreciated.

Regards,
Sahasra.

[Deeksham]

Hi Sahasra,
Thanks for getting back to me. 
Other dashboards with same data source refresh works fine except for 2 dashboards, ODBC connection settings are same for all the dashboards. 
My colleague was able to refresh the dashboard which i got error as well.

[v-sgandrathi]

Hi @Deeksham,

As you mentioned you and your colleague have same data source and ODBC connection settings are same for all the dashboards here are the new points which you can check once.

• Check whether the 'ALL GL ACCTS' table is available in the NetSuite and it has relevant data. There must be no removed, renamed, or modification on the columns.
• Ensure your user account has the same access rights to the "ALL GL ACCTS" table as your colleague. Test your access by logging into the NetSuite database directly using a query tool.
• Verify that your network connection is stable and free from interruptions. If using a VPN, make sure it is working properly, or try refreshing the dashboard without it.
• Check that no firewall or security software is blocking your connection to the data source, as this could prevent a successful refresh.

Please Accept as solution If this post clears your issue and a Kudos would be appreciated.

Thankyou.

[v-sgandrathi]

Hi @Deeksham ,

I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.

Regards,
Sahasra.