Power BI can connect to GCP BigQuery through its provided connector. However, some reported that they’ve encountered the refresh failure as seen below. Even though the error message suggests that the quota for the API requests per user per minute may be exceeded, some reported that the error still occurs even if with a small dataset …
Connect Power BI to GCP BigQuery using Simba Drivers Read More »
I’ve been using Power BI for a couple months now, not as a developer, but as a system architecture. I may not deal with dashboard and report development on a daily basis, however, I, as an end user, use Power BI extensively to monitor Azure and Power BI usage including audit and billing. I would …
Validate Performance Improvement Using Query Folding Feature in Power BI Read More »
If you’re searching for “export Oracle BLOB”, the article, by Jeff Smith, titled “Exporting Multiple BLOBs with Oracle SQL Developer” using Oracle SQL Developer” is usually at the top of the search result. The SQL Developer features the Shopping Cart without using scripts to export BLOBs out of a database. I don’t want to go …
This post is just a quick note to myself on how to configure JBDC on Oracle Enterprise Data Quality (OEDQ) to connect to different databases. First let’s talk about connecting to Oracle database. By default, OEDQ’s Data Store can only connect Oracle database by SID, but not by Service Name. Fortunately, the JDBC connection …
If for some reason, you could not install the APEX sample packaged application via Application Builder > Packaged Applications interface, you have an option of installing it by importing the SQL script (fxxxx.sql). In my case, when installing via the Packaged Applications interface, I got the following error: While working with DBA and Oracle support …
Install APEX’s Sample Packaged Application by Importing its SQL Script Read More »
Installation Install the Oracle Database Gateways 11g R2 (11.2). See the screen snapshots of the installation here. Configuration During the installation, the following+ default initialization parameter file is created: [ORACLE_DG_HOME]\dg4msql\admin\initdg4msql.ora dg4msql = Database gateway for Microsoft SQL Server. If you choose a different database option, use the appropriate path name. Copy initdg4msql.ora to a new …
