Can not get data in Power BI using SuiteCRM Sys

Live Connectivity CData Drivers
, ,
1

I’m using CData SuiteCRM. Previously the connection was established and could bring in data to Power BI, as well as refresh on Power BI service.

But after setting the following for Caching, the tables cannot be found from Power BI, although can be found in the Connector:

bf528c68-1362-409b-ac27-ece3586deb66.png
bf528c68-1362-409b-ac27-ece3586deb66.png361×142 3.13 KB

When Auto Cache was False, it was working. I enabled it as true to improve the refresh speed in Power BI service.

I also cleared cache in Power BI before running the refresh. How can I solve this? I’m using the latest version of CData

2

Hello KaziMahmud,

Thankyou for the details. We have tried the same previously CacheMetadata=True/AutoCache=True setup against a SuiteCRM connection in Power BI Desktop and could see the catalog/tables without issue, so this isn’t a universal problem with that configuration.

A couple of things to check on your end:

  • Does C:\Program Files\CData have write access for the account Power BI is running as? That folder can be permission-restricted.
  • Try deleting the existing cache file and reconnecting fresh a partially-written cache from an earlier failed refresh can cause this.

If it still fails, please reach out to support@cdata.com for further troubleshoot the issue in depth.

3

Hi ​ @AnkitK  ,

Thanks for the suggestion. I tried refreshing on of the tables after removing the existing cache file. And the following error shows:

77da1f52-f6df-4dc1-b479-45b13602eada.png
77da1f52-f6df-4dc1-b479-45b13602eada.png499×204 4.36 KB

OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [HY000] 4 Unable to get schema.

4

Hello ​ @KaziMahmud

To troubleshoot further, we’ll need the detailed logs. Please email support@cdata.com with this thread, our team can pick it up from there.

In the meantime, try setting CacheMetadata=False while keeping AutoCache=True that should get your refreshes working again.