# \#power-bi **URL:** https://community.cdata.com/tag/power-bi/43.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [Can not get data in Power BI using SuiteCRM Sys](https://community.cdata.com/t/can-not-get-data-in-power-bi-using-suitecrm-sys/1337)
**Author:** [@KaziMahmud](https://community.cdata.com/u/KaziMahmud)\ **Replies:** 3\ **Last updated:** [October 9, 2026, 11:07am UTC](https://community.cdata.com/t/can-not-get-data-in-power-bi-using-suitecrm-sys/1337 "2026-10-09T11:07:55Z")
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 fr… --- ## [How to Connect API Data sources to Power BI using CData API Driver](https://community.cdata.com/t/how-to-connect-api-data-sources-to-power-bi-using-cdata-api-driver/1298)
**Author:** [@Anusha\_M\_B](https://community.cdata.com/u/Anusha_M_B)\ **Replies:** 0\ **Last updated:** [June 2, 2026, 10:10am UTC](https://community.cdata.com/t/how-to-connect-api-data-sources-to-power-bi-using-cdata-api-driver/1298 "2026-06-02T10:10:22Z")
Skip the custom connector. The CData API Driver pulls REST API data directly into Power BI in a few steps. For more information, refer to: How to Connect API Data Sources to Power BI Using CData API Driver --- ## [Start Visualizing Facebook Ads Performance Using CData](https://community.cdata.com/t/start-visualizing-facebook-ads-performance-using-cdata/1148)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [July 30, 2025, 7:13pm UTC](https://community.cdata.com/t/start-visualizing-facebook-ads-performance-using-cdata/1148 "2025-07-30T19:13:41Z")
Hey CData Community! Feeling lost in a sea of Facebook Ads charts, clicks, and conversions? Well, running campaigns is just the first step. Making sense of the data is where the real impact begins. With CData Facebook… --- ## [Cdata Power BI Connector](https://community.cdata.com/t/cdata-power-bi-connector/1105)
**Author:** [@natykarina](https://community.cdata.com/u/natykarina)\ **Replies:** 3\ **Last updated:** [June 10, 2025, 11:58am UTC](https://community.cdata.com/t/cdata-power-bi-connector/1105 "2025-06-10T11:58:37Z")
Since this morning at 08.00 we have problems with the Cdata Driver Connector for Power BI. This error is from Power BI Desktop I tried to recreate the connection, but without success. --- ## ["The table has no visible columns and cannot be queried." error when refreshing semantic model in Power BI Online](https://community.cdata.com/t/the-table-has-no-visible-columns-and-cannot-be-queried-error-when-refreshing-semantic-model-in-power-bi-online/1091)
**Author:** [@Naomi\_Y](https://community.cdata.com/u/Naomi_Y)\ **Replies:** 1\ **Last updated:** [May 14, 2025, 5:55pm UTC](https://community.cdata.com/t/the-table-has-no-visible-columns-and-cannot-be-queried-error-when-refreshing-semantic-model-in-power-bi-online/1091 "2025-05-14T17:55:44Z")
I’m unable to refresh my Power BI Semantic Model on Power BI Online and am running into the error below. I’m using the QuickBooks Power BI Connector. Data source error{“error”:{“code”:“DM\_GWPipeline\_Gateway\_MashupData… --- ## [Using DirectQuery in Power BI with CData Power BI Connectors](https://community.cdata.com/t/using-directquery-in-power-bi-with-cdata-power-bi-connectors/1033)
**Author:** [@Cameron\_L](https://community.cdata.com/u/Cameron_L)\ **Replies:** 0\ **Last updated:** [February 28, 2025, 9:52pm UTC](https://community.cdata.com/t/using-directquery-in-power-bi-with-cdata-power-bi-connectors/1033 "2025-02-28T21:52:45Z")
CData Power BI Connectors support real-time integration with any data source using DirectQuery in Power BI. With DirectQuery, Power BI users can seamlessly work with large datasets while avoiding the issues associated wi… --- ## [Authenticating Connections from the Client Side](https://community.cdata.com/t/authenticating-connections-from-the-client-side/1016)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [February 4, 2025, 5:14am UTC](https://community.cdata.com/t/authenticating-connections-from-the-client-side/1016 "2025-02-04T05:14:40Z")
Hey CData Community! When using CData ODBC Drivers and Power BI Connectors to connect to a data source, authentication is usually handled through the ODBC DSN settings. However, what if you want more flexibility? Some u… --- ## [CData Drivers Now Support UI URL Capture](https://community.cdata.com/t/cdata-drivers-now-support-ui-url-capture/1011)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [January 31, 2025, 11:06am UTC](https://community.cdata.com/t/cdata-drivers-now-support-ui-url-capture/1011 "2025-01-31T11:06:51Z")
Hey CData Community! When analyzing business data using BI tools like Power BI and Tableau, you’ve probably found yourself thinking, “This is interesting” or “I need to take action on this item.” After all, the primary … --- ## [anyone trying to connect Hubspot and Intacct to PowerBI?](https://community.cdata.com/t/anyone-trying-to-connect-hubspot-and-intacct-to-powerbi/998)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [January 17, 2025, 3:12pm UTC](https://community.cdata.com/t/anyone-trying-to-connect-hubspot-and-intacct-to-powerbi/998 "2025-01-17T15:12:44Z")
Stumbled on these guys Customers - DataBlend but they’re only Inacct into Hubspot, and we recently had a user in Connect Cloud purchase for Intacct and Hubspot into PowerBI and other destinations. Is this something othe… --- ## [Intermittent Query failures to NetSuite - also, new to Cdata Connect Cloud](https://community.cdata.com/t/intermittent-query-failures-to-netsuite-also-new-to-cdata-connect-cloud/976)
**Author:** [@jfuhrman](https://community.cdata.com/u/jfuhrman)\ **Replies:** 3\ **Last updated:** [December 20, 2024, 6:35am UTC](https://community.cdata.com/t/intermittent-query-failures-to-netsuite-also-new-to-cdata-connect-cloud/976 "2024-12-20T06:35:15Z")
I wanted to reach out regarding some issues I’m having with a NetSuite integration in our CData Connect Cloud instance. The failures seem to be intermittent, some queries using the same connection work, others do not. I … --- ## [Missing Transactions in Power BI Data Model with QuickBooks Online Connector](https://community.cdata.com/t/missing-transactions-in-power-bi-data-model-with-quickbooks-online-connector/943)
**Author:** [@Shakil](https://community.cdata.com/u/Shakil)\ **Replies:** 2\ **Last updated:** [November 20, 2024, 6:01pm UTC](https://community.cdata.com/t/missing-transactions-in-power-bi-data-model-with-quickbooks-online-connector/943 "2024-11-20T18:01:59Z")
I created a Power BI data model using the QuickBooks Online connector and successfully built some basic reports. However, I noticed that certain transactions are missing from the data. I queried all available tables but … --- ## [Which data sources support DirectQuery mode in Power BI?](https://community.cdata.com/t/which-data-sources-support-directquery-mode-in-power-bi/804)
**Author:** [@PratikV](https://community.cdata.com/u/PratikV)\ **Replies:** 0\ **Last updated:** [June 27, 2024, 2:48pm UTC](https://community.cdata.com/t/which-data-sources-support-directquery-mode-in-power-bi/804 "2024-06-27T14:48:21Z")
Repeatedly, customers have raised inquiries regarding the compatibility of Power BI’s direct query mode with various data sources. They seek clarification on which this feature supports specific data sources. Here is a … --- ## [Edit Generated Schema Files](https://community.cdata.com/t/edit-generated-schema-files/747)
**Author:** [@Naomi\_Y](https://community.cdata.com/u/Naomi_Y)\ **Replies:** 0\ **Last updated:** [June 5, 2024, 7:59pm UTC](https://community.cdata.com/t/edit-generated-schema-files/747 "2024-06-05T19:59:21Z")
In this article, I will outline how to edit a newly generated schema file using our Connectors. This article will use our QuickBooks Online Power BI Connector as an example; however, this walkthrough is applicable to any… --- ## [CData ODBC Scheduled Refresh](https://community.cdata.com/t/cdata-odbc-scheduled-refresh/740)
**Author:** [@Abdul](https://community.cdata.com/u/Abdul)\ **Replies:** 2\ **Last updated:** [June 4, 2024, 9:57am UTC](https://community.cdata.com/t/cdata-odbc-scheduled-refresh/740 "2024-06-04T09:57:18Z")
I am using CData Connector (ODBC) with PowerBI to access my data (Zoho CRM). Is there a way to configure a scheduled refresh? Is this even something that can help me? --- ## [“\[INVALID\_PARAMETER\] Invalid search query” error when trying to query NetSuite tables](https://community.cdata.com/t/invalid-parameter-invalid-search-query-error-when-trying-to-query-netsuite-tables/741)
**Author:** [@DylanO](https://community.cdata.com/u/DylanO)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 7:19pm UTC](https://community.cdata.com/t/invalid-parameter-invalid-search-query-error-when-trying-to-query-netsuite-tables/741 "2024-06-03T19:19:10Z")
When using any of our NetSuite connectors, you may see the following error when trying to query a table: \[INVALID\_PARAMETER\] Invalid search query. Detailed unprocessed description follows. Search error occurred: Field ‘\<… --- ## [Which Data Source supports Direct Query Mode in Power](https://community.cdata.com/t/which-data-source-supports-direct-query-mode-in-power/710)
**Author:** [@PratikV](https://community.cdata.com/u/PratikV)\ **Replies:** 2\ **Last updated:** [May 13, 2024, 10:45am UTC](https://community.cdata.com/t/which-data-source-supports-direct-query-mode-in-power/710 "2024-05-13T10:45:56Z")
Hi All, Repeatedly, customers have raised inquiries regarding the compatibility of Power BI’s direct query mode with various data sources. They seek clarification on which specific data sources are supported by this fea… --- ## [Does Connect Cloud support incremental refreshes in PowerBI?](https://community.cdata.com/t/does-connect-cloud-support-incremental-refreshes-in-powerbi/640)
**Author:** [@James\_T](https://community.cdata.com/u/James_T)\ **Replies:** 3\ **Last updated:** [April 25, 2024, 7:57pm UTC](https://community.cdata.com/t/does-connect-cloud-support-incremental-refreshes-in-powerbi/640 "2024-04-25T19:57:36Z")
I am importing some very large tables into PowerBI. Each time the data refreshes, the process gets slowed down since all of the data is getting requested/refreshed. Does Connect Cloud support updating/refreshing the dat… --- ## [odbc error hy000 using PowerBI](https://community.cdata.com/t/odbc-error-hy000-using-powerbi/631)
**Author:** [@garybray](https://community.cdata.com/u/garybray)\ **Replies:** 5\ **Last updated:** [February 15, 2024, 10:04pm UTC](https://community.cdata.com/t/odbc-error-hy000-using-powerbi/631 "2024-02-15T22:04:05Z")
Have a user that gets the following error when trying to refresh the data & import more data using PowerBI. How can I remedy this for her? --- ## [Cdata: PowerBI + Sage Intacct Performance](https://community.cdata.com/t/cdata-powerbi-sage-intacct-performance/605)
**Author:** [@taranr\_sockeye](https://community.cdata.com/u/taranr_sockeye)\ **Replies:** 4\ **Last updated:** [February 5, 2024, 8:24pm UTC](https://community.cdata.com/t/cdata-powerbi-sage-intacct-performance/605 "2024-02-05T20:24:14Z")
Hi! Two pronged question. What’s typical performance that should be expected with Cdata’s Sage Intacct / Power BI connector? \[I’m getting about 250k rows loaded from a large data set in an hour\] Are there any tr… --- ## [Can I schedule a refresh in PowerBI using CData Connect Cloud?](https://community.cdata.com/t/can-i-schedule-a-refresh-in-powerbi-using-cdata-connect-cloud/590)
**Author:** [@James\_T](https://community.cdata.com/u/James_T)\ **Replies:** 1\ **Last updated:** [January 2, 2024, 10:01pm UTC](https://community.cdata.com/t/can-i-schedule-a-refresh-in-powerbi-using-cdata-connect-cloud/590 "2024-01-02T22:01:40Z")
I am using CData Connect Cloud with PowerBI to access my data (Sage Intacct). Is there a way to configure a scheduled refresh? Is this even something that Connect Cloud supports? --- ## [How to modify User Defined Views](https://community.cdata.com/t/how-to-modify-user-defined-views/571)
**Author:** [@Euxhenio](https://community.cdata.com/u/Euxhenio)\ **Replies:** 0\ **Last updated:** [December 14, 2023, 9:22pm UTC](https://community.cdata.com/t/how-to-modify-user-defined-views/571 "2023-12-14T21:22:21Z")
In the following tutorial, we will describe how to modify an existing User Defined View. For this example, we are using the CData ODBC Driver for Salesforce. The list of the User Defined Views can be found in the DSN con… --- ## [10,000 Table Limit in Excel and Power BI Navigator](https://community.cdata.com/t/10-000-table-limit-in-excel-and-power-bi-navigator/557)
**Author:** [@Cameron\_L](https://community.cdata.com/u/Cameron_L)\ **Replies:** 0\ **Last updated:** [December 11, 2023, 3:55pm UTC](https://community.cdata.com/t/10-000-table-limit-in-excel-and-power-bi-navigator/557 "2023-12-11T15:55:56Z")
When attempting to load data into Microsoft Excel or Power BI, the Navigator that opens has a limitation where it can only display the first 10,000 tables at once. Since certain data sources, such as SAP, deal with more … --- ## [How to connect one Power BI Premium tabular model to another as a datasource?](https://community.cdata.com/t/how-to-connect-one-power-bi-premium-tabular-model-to-another-as-a-datasource/484)
**Author:** [@Malcolm](https://community.cdata.com/u/Malcolm)\ **Replies:** 2\ **Last updated:** [November 17, 2023, 5:00pm UTC](https://community.cdata.com/t/how-to-connect-one-power-bi-premium-tabular-model-to-another-as-a-datasource/484 "2023-11-17T17:00:38Z")
Hi all, We are migrating from on-prem tabular models to PowerBI Premium models. Most datasources work flawlessly (including the CDATA Snowflake connector). However, we have been unable to use another tabular model as a … --- ## [Unable to find the CData Connector listed in Power BI Desktop due to the 'Unverified Connectors...' warning.](https://community.cdata.com/t/unable-to-find-the-cdata-connector-listed-in-power-bi-desktop-due-to-the-unverified-connectors-warning/529)
**Author:** [@Gejsi\_D](https://community.cdata.com/u/Gejsi_D)\ **Replies:** 0\ **Last updated:** [November 16, 2023, 7:30pm UTC](https://community.cdata.com/t/unable-to-find-the-cdata-connector-listed-in-power-bi-desktop-due-to-the-unverified-connectors-warning/529 "2023-11-16T19:30:43Z")
After installing the most recent hotfix for your CData Power BI Connector, it is possible to face the ‘Uncertified Connectors…’ warning and furthermore not be able to find the desired CData Connector listed in Power BI. … --- ## [Power BI, ODBC – Requested registry access is not allowed.](https://community.cdata.com/t/power-bi-odbc-requested-registry-access-is-not-allowed/524)
**Author:** [@IrdiD](https://community.cdata.com/u/IrdiD)\ **Replies:** 0\ **Last updated:** [November 14, 2023, 9:59pm UTC](https://community.cdata.com/t/power-bi-odbc-requested-registry-access-is-not-allowed/524 "2023-11-14T21:59:11Z")
The ‘Requested registry access is not allowed’ error typically indicates that you do not have permission to write to the registry. As the driver’s connection information is stored in the registry, you will need … --- ## [Power BI Connector – move PQX file on OneDrive machine](https://community.cdata.com/t/power-bi-connector-move-pqx-file-on-onedrive-machine/517)
**Author:** [@Cameron\_L](https://community.cdata.com/u/Cameron_L)\ **Replies:** 0\ **Last updated:** [November 9, 2023, 6:23pm UTC](https://community.cdata.com/t/power-bi-connector-move-pqx-file-on-onedrive-machine/517 "2023-11-09T18:23:49Z")
If you aren’t seeing the CData connector in the list of available connections in the “Get Data” window, it means that the installer was unable to copy the necessary file to the custom connectors folder. Typically, this f… --- ## [Error: Your file was published, but disconnected in Power BI](https://community.cdata.com/t/error-your-file-was-published-but-disconnected-in-power-bi/446)
**Author:** [@Gezim\_Jace](https://community.cdata.com/u/Gezim_Jace)\ **Replies:** 0\ **Last updated:** [October 9, 2023, 9:39pm UTC](https://community.cdata.com/t/error-your-file-was-published-but-disconnected-in-power-bi/446 "2023-10-09T21:39:09Z")
This error usually happens when connecting to a local data source. If your use case is cloud based (non-local) we highly recommend the use of Connect Cloud as it removes the Power BI Gateway as an element and makes the f… --- ## [ODBC Drivers and Power BI Components error: ODBC: ERROR \[08001\]](https://community.cdata.com/t/odbc-drivers-and-power-bi-components-error-odbc-error-08001/445)
**Author:** [@Dario\_R](https://community.cdata.com/u/Dario_R)\ **Replies:** 0\ **Last updated:** [October 9, 2023, 8:34pm UTC](https://community.cdata.com/t/odbc-drivers-and-power-bi-components-error-odbc-error-08001/445 "2023-10-09T20:34:27Z")
If you’re using ODBC drivers or Power BI Components in Power BI that rely on OAuth authentication to connect to a Source/API, it’s essential to know that some sources require users to reauthenticate after a certain perio… --- ## [Creating User Defined Views](https://community.cdata.com/t/creating-user-defined-views/406)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [September 20, 2023, 5:31pm UTC](https://community.cdata.com/t/creating-user-defined-views/406 "2023-09-20T17:31:59Z")
The CData Drivers and Connectors allow you to define a virtual table whose contents are decided by a pre-configured query. These are called User Defined Views, which are useful in situations where you cannot directly con… --- ## ["Error opening file for writing..." when installing CData Drivers](https://community.cdata.com/t/error-opening-file-for-writing-when-installing-cdata-drivers/380)
**Author:** [@Gejsi\_D](https://community.cdata.com/u/Gejsi_D)\ **Replies:** 0\ **Last updated:** [September 6, 2023, 8:24pm UTC](https://community.cdata.com/t/error-opening-file-for-writing-when-installing-cdata-drivers/380 "2023-09-06T20:24:47Z")
The ‘Error opening file for writing…’ usually indicates that you are trying to overwrite a file that is in use. You’ll need to close any other applications you have which is using the connector (such as ODBC Da… [Next page](https://community.cdata.com/tag/power-bi/43.md?match_all_tags=true&page=1&tags%5B%5D=power-bi)