# Can not get data in Power BI using SuiteCRM Sys **URL:** \ **Category:** CData Drivers\ **Tags:** question, suitecrm, power-bi\ **Created:** [October 8, 2026, 9:36am UTC](https://community.cdata.com/t/can-not-get-data-in-power-bi-using-suitecrm-sys/1337 "2026-10-08T09:36:17Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![KaziMahmud](https://avatars.discourse-cdn.com/v4/letter/k/8edcca/32.png) [@KaziMahmud](https://community.cdata.com/u/KaziMahmud)\ **Post date:** [October 8, 2026, 9:36am UTC](https://community.cdata.com/t/can-not-get-data-in-power-bi-using-suitecrm-sys/1337/1 "2026-10-08T09:36:18Z")
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](https://us1.discourse-cdn.com/cdata/original/2X/2/2c4a6c966ab5310f053a9d1323f94cb1ee946dbb.png) 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 ---
**Author:** ![AnkitK](https://avatars.discourse-cdn.com/v4/letter/a/bc8723/32.png) [@AnkitK](https://community.cdata.com/u/AnkitK)\ **Post date:** [October 8, 2026, 11:03am UTC](https://community.cdata.com/t/can-not-get-data-in-power-bi-using-suitecrm-sys/1337/2 "2026-10-08T11:03:28Z")
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](mailto:support@cdata.com) for further troubleshoot the issue in depth. ---
**Author:** ![KaziMahmud](https://avatars.discourse-cdn.com/v4/letter/k/8edcca/32.png) [@KaziMahmud](https://community.cdata.com/u/KaziMahmud)\ **Post date:** [October 8, 2026, 11:34am UTC](https://community.cdata.com/t/can-not-get-data-in-power-bi-using-suitecrm-sys/1337/3 "2026-10-08T11:34:41Z")
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](https://us1.discourse-cdn.com/cdata/original/2X/8/89e0ff48335a38fc0a0473142ad4127231897470.png) > **OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [HY000] 4 Unable to get schema.** ---
**Author:** ![AnkitK](https://avatars.discourse-cdn.com/v4/letter/a/bc8723/32.png) [@AnkitK](https://community.cdata.com/u/AnkitK)\ **Post date:** [October 9, 2026, 11:07am UTC](https://community.cdata.com/t/can-not-get-data-in-power-bi-using-suitecrm-sys/1337/4 "2026-10-09T11:07:55Z")
Hello ​ @KaziMahmud To troubleshoot further, we’ll need the detailed logs. Please email [support@cdata.com](mailto: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.