mariadb-corporation/mariadb-powerbi

Power BI DirectQuery Connector

MariaDB Power BI Connector

About

MariaDB has created a custom Power BI DirectQuery Connector which has undergone the Microsoft certification process and will be available in the October 2020 release of Microsoft Power BI. In the interim, it is available for download from our website.

Requirements

• Microsoft Power BI Desktop

  • Download

• MariaDB ODBC Driver v3.1.7 or later

  • Download

• MariaDB Power BI Connector

  • Download

Connector extensibility in Power BI

Power BI can connect to data by using existing connectors and generic data sources, like ODBC, OData, OLE DB, Web, CSV, XML, and JSON. Or, developers can enable new data sources with custom data extensions called custom connectors. Some custom connectors are certified and distributed by Microsoft as certified connectors.

To use non-certified custom connectors that you or a third party have developed, you must adjust the Power BI Desktop security settings to allow extensions to load without validation or warning. Because this code can handle credentials, including sending them over HTTP, and ignore privacy levels, you should only use this security setting if you absolutely trust your custom connectors.

Another option is for the developer to sign the connector with a certificate, and provide the information you need to use it without changing your security settings. For more information, see About trusted third-party connectors.

Custom connectors

Non-certified custom connectors can range from small business-critical APIs to large industry-specific services that Microsoft hasn't released a connector for. Many connectors are distributed by vendors. If you need a specific data connector, contact the vendor.

To use a non-certified custom connector, put the connector .pq, .pqx, .m, or .mez file in the [Documents]\Power BI Desktop\Custom Connectors folder. If the folder doesn't exist, create it.

Adjust the data extension security settings as follows:

In Power BI Desktop, select File > Options and settings > Options > Security.

Under Data Extensions, select (Not Recommended) Allow any extension to load without validation or warning. Select OK, and then restart Power BI Desktop.

The default Power BI Desktop data extension security setting is (Recommended) Only allow Microsoft certified and other trusted third-party extensions to load. With this setting, if there are non-certified custom connectors on your system, the Uncertified Connectors dialog box appears at Power BI Desktop startup, listing the connectors that can't securely load.

To resolve the error, you can either change your Data Extensions security setting, or remove the uncertified connectors from your Custom Connectors folder.

Certified connectors

A limited subset of data extensions is considered certified. While Microsoft distributes the connectors, it's not responsible for their performance or continued function. The third-party developer who created the connector is responsible for its maintenance and support.

In Power BI Desktop, certified third-party connectors appear in the list in the Get Data dialog box, along with generic and common connectors. You don't need to adjust security settings to use the certified connectors.

mariadb-powerbi's Issues

unable to connect

I have problem to connect to MariaDB from Power BI using ODBC connector

Not sure why?

Thanks.

DirectQuery in PowerBI: We couldn't fold the expression of the data source

Hello,

Whenever I try to add a database field to a table (even an empty one) in PowerBI it gives me this message:
OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression..

Any aggregates do not work either, they give me the same error.

I simply can't seem to get around this.

Thanks in advance!

Power BI Connect to MySql - error 10060

I have established my MariaDB connection on my pc and when I use it in Power BI I get this error

Can I please get help to resolve this?
Thank you,

DataType issues

Hello,

Regarding the issues reported here: #15, doing CAST(column as int) on an already int data type field should not happen, this is actually an real issue when the table has an index on that int column and when filtering it prevents usage of the index. Please can you fix this bug - please see more details here: https://jira.mariadb.org/browse/ODBC-358.

Thanks.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTEGER) = ?

Hi,

I am getting this issue when filtering a column in PowerBI.

PowerBI:
Version: 2.114.864.0 64-bit (Februar 2023)

MariaDB ODBC Connector:
3.1.17

Steps to reproduce:

Choose a table and select "Edit Query". In Power Query Editor select an Integer-Column and filter by any number. In the example faktentyp_did has to be 1 to be selected.

let
    Source = MariaDB.Contents("mydb.cluster-ct9n3wlgjhhm.eu-central-1.rds.amazonaws.com", "performance_mart", true),
    fakt_reisezentrum_halbstundenwerte_Table = Source{[Name="fakt_reisezentrum_halbstundenwerte",Kind="Table"]}[Data],
    #"Renamed Columns" = Table.RenameColumns(fakt_reisezentrum_halbstundenwerte_Table,{{"anzahl_kunden", "# Anzahl Kunden"}, {"summe_prozesszeit_empfang", "# Prozesszeit Empfang"}, {"summe_wartezeit", "# Wartezeit Gesamt"}, {"summe_transaktionszeit", "# Transaktionszeit Gesamt"}}),
    #"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each [faktentyp_did] = 1)
in
    #"Filtered Rows"

Click "Close & Apply". PowerBI will then try to get the data, but will fail with the following error:

The tracelog can be found here, it was too long for github.

Not able to connect with Maria Db

I want to use MariaDB database in Power BI however whenever i am entering server details in format "serverIP:port;databasename" i am getting the following error. [ma-3.1.11]Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 0

Can someone help me to solve the above issue

View Native Query not available

"View native query" is never available even with just opening the table or, after duplicating a column.

Excessively slow data access

Greetings,

I try to access a MariaDB server from PowerBI and experience some major response times.

In a blank report, connecting to any database takes between 5 and 10 minutes to get the list of tables, followed with a solid hour to fetch the selected table preview.

When I query the server through HeidiSQL I don't notice any performance issues.

The server is running MariaDB 10.1.34, PowerBI is up to date and we installed MariaDB ODBC Driver 64-bit v3.1.15.

Any suggestions to figure out this issue?

Regards,

Eric.

PowerBI ODBC Error

we are facing issue in our Power BI refreshes from Power BI Service using the MariaDB ODBC Connector (3.1.18).

We are intermittently getting the below error message in our Power BI reports. Could you please help us understand and fix this issue?.

{
"error": {
"code": "DM_GWPipeline_Gateway_MashupDataAccessError",
"pbi.error": {
"code": "DM_GWPipeline_Gateway_MashupDataAccessError",
"parameters": {

  },
  "details": [
    {
      "code": "DM_ErrorDetailNameCode_UnderlyingErrorCode",
      "detail": {
        "type": 1,
        "value": "-2147467259"
      }
    },
    {
      "code": "DM_ErrorDetailNameCode_UnderlyingErrorMessage",
      "detail": {
        "type": 1,
        "value": "ODBC: ERROR [HY000] [ma-3.1.18][10.2.24-MariaDB-log]"
      }
    },
    {
      "code": "DM_ErrorDetailNameCode_UnderlyingHResult",
      "detail": {
        "type": 1,
        "value": "-2147467259"
      }
    },
    {
      "code": "Microsoft.Data.Mashup.ValueError.DataSourceKind",
      "detail": {
        "type": 1,
        "value": "Odbc"
      }
    },
    {
      "code": "Microsoft.Data.Mashup.ValueError.DataSourcePath",
      "detail": {
        "type": 1,
        "value": "dsn=MariaDB_194"
      }
    },
    {
      "code": "Microsoft.Data.Mashup.ValueError.OdbcErrors",
      "detail": {
        "type": 1,
        "value": "error \"Microsoft.Mashup.Engine1.Runtime.ValueException: [Expression.Error] Value was not specified.#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.CreateValueForNotImplemented(INotImplementedExpression expression)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.ListValue.DemandArrayListValue.get_Item(Int32 index)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.BufferedListValue.BufferedValueReference.get_Value()#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.TableTypeValue.FromValue(ListValue columns, TypeValue defaultColumnType)#(cr)#(lf) at Microsoft.Mashup.Engine1.Library.Table.TableModule.Table.FromRowsFunctionValue.TypedInvoke(ListValue rows, Value columns)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue2`3.Invoke(Value arg0, Value arg1)#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.<>c__DisplayClass23_0.<CreateValueForRecord>b__0(Int32 index)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.RecordValue.DemandRecordValue.get_Item(Int32 index)#(cr)#(lf) at Microsoft.Data.Mashup.ProviderCommon.MashupResource.TryGetValue(Func`1 getValue, IValue& value, String& errorMessage)#(cr)#(lf)Record\""
      }
    },
    {
      "code": "Microsoft.Data.Mashup.ValueError.Reason",
      "detail": {
        "type": 1,
        "value": "DataSource.Error"
      }
    }
  ],
  "exceptionCulprit": 1
}

}
}

Unable to find connector in Power BI Desktop

We are using Power BI Desktop (September 2022). We downloaded the ODBC connector for Windows (both 32 and 64 bit) and no matter how many times we try, including reboots, we are unable to find the MariaDB connector in Power BI Desktop. This is with ODBC Connector 3.1.17. Can you help?

Availability of custom query option in connector

Following the answer received in issue #32 I understand it'll no longer be possible to download the standalone connector, as it will be included in core PowerBI.

However, the included connector lacks a functionality which is available, for example, for the MySQL connector, and which was available in your 1.0.7-beta version; that is, the ability to load data using a custom query.

Will that functionality be available in the future? Or is it not planned to include it?

VARCHAR and LONGVARCHAR date types syntax error

Dear ones, Hello!

I am having problems of sorts with importing data. I checked in Issue #4 for the Int32/Int64 type problem and adjusted those settings, which no longer generated any impact.

However, I am having problems with the VARCHAR and LONGVARCHAR types, as we can see in these images:

If you need more information, let me know!

Edit-1:
I removed the failing columns and the import worked again.

MariaDB connection not available in PowerBI

Please, help me, must be doing something wrong.
Trying to connect PowerBI desktop to mariadb hower this connection type is not contained in the list of available connections even after completion of adapter installation:

https://mariadb.com/resources/blog/getting-started-with-the-mariadb-direct-query-adapter-for-microsoft-power-bi/

any clue how can this be resolved? Has anyone experienced it?

thanks!

Unable to configure scheduled refresh of published dataset, unsupported data source

I used the MariaDB connector in PowerBI Desktop (Aug 2021 version) to connect to a data source and save a .pbix file on a server. I then published that file as a dataset in our Microsoft PowerBI Cloud Premium Workspace. We have the PowerBI Gateway installed on our server for use with our previous MySQL data source, where we could configure the Gateway connection, then schedule automated refreshes of the published PBI dataset.

When we converted from MySQL to MariaDB and attempted the same process we ran into a snag. After publishing the MariaDB dataset to the PBI Cloud Workspace, we are unable to configure the Gateway Connection and setup a scheduled refresh of the dataset.

Do you know if published .pbix files with the 'MariaDB.Contents' connection string are compatible with the PowerBI Gateway? In order to configure the gateway connection and schedule refreshes of the data? I'm trying to determine if our Gateway servers need to have a config enabled, or if MariaDB is not supported by the PowerBI Gateway at all.

Refresh Error:
Data source error: Unable to refresh the model (id=697226) because it references an unsupported data source.
Cluster URI: WABI-US-NORTH-CENTRAL-E-PRIMARY-redirect.analysis.windows.net
Activity ID: 9e19bded-5df1-4386-9c8d
Request ID: ad8dd51b-44a8-eaa6-8a3a
Time: 2021-09-29 21:23:17Z

PowerBI Workspace Message:
Unable to determine the data source due to unknown functions. When custom connectors are used, the error can happen if gateway doesn't have the extension enabled. Details: Static analysis failed in gateway. gatewayObjectId:3ea6e53f-b2f1-48e3-a163-c913c3e, resultCode:FailedWithUnknownFunctions Query contains unknown function name: MariaDB.Contents .
Data source for Query1

Cannot use parameters in the grafic UI for configuring the datasource

I am currently using version 1.0.7-beta of the connector, since latest version 1.1.X does not include the custom SQL option.

When setting data source parameters, it requires you to hardcode those in the "Data Source" and "Database" field, those are then used as string:

However, once you have setup the datasource, it allows to replace the hardcoded strings with parameters:

Once you have replaced the parameters, however, you can no longer use the grafic UI to change the query, as the "Data Source" and "Database" come up empty, and you'd need to hardcode them again, and then replace them again, or work in the Power Query editor.

Converting datetime to text raises an error

In power bi, using the mariadb connector downloaded from: https://mariadb.com/downloads/connectors/

this error raises when you convert datetime to text: https://imgur.com/a/dmn6Olx

I have to to this convesion because i have to run a python script and in order to prevent dates column to get into the python script as Microsoft.olbe.time (see: https://stackoverflow.com/questions/51929420/python-script-in-power-bi-returns-date-as-microsoft-oledb-date) it is a must-do step during data modeling.

To reproduce

• get any column (import mode) in datetime and convert it into text
• apply changes in power query editor

Syntax error with if statement

When using "contains" in the "add conditional column" dialog, the query runs on syntax error:

corresponding M code:

Datasource is in import mode!

Problem uploading Power BI Report to Power BI Service Portal

I'm working with Power BI desktop and MariaDB without problems, but when I upload the report to the service portal I can't configure any gateway.

Please, How I can connect my report in the portal with de source of data?

Thank you on advance.

Creating visualization throws "Object reference not set to an instance of an object."

When attempting to create a new pie chart visualization Power BI Desktop is throwing a "Object reference not set to an instance of an object" exception. (See exception,txt for full error log)

Step to reproduce:

1.) Clone a repository that is used to populate a MariaDB ColumnStore database:

git clone https://github.com/mariadb-corporation/dev-example-columnstore-quickstart

and walkthrough the steps to set up a new Docker container, create schema, and load data into MariaDB ColumnStore (Community Server).

2.) Within the (containerized) database, execute the following to create a new user, which will be used by Power BI Desktop to connect to MariaDB.

CREATE USER 'powerbi_user'@'%' IDENTIFIED BY 'Password123!';
GRANT ALL PRIVILEGES ON *.* TO 'powerbi_user'@'%' WITH GRANT OPTION;

3.) Within Power BI Desktop use "Get Data" to establish a connection to MariaDB.

4.) Select airlines, airports, and flights tables within the Power BI Navigator window to create models for each.

5.) Create a new 1-Many(*) relationship between airlines.iata_code and flights.carrier (See relationship.png)

6.) Create a new Pie Chart visualization. Assign airlines.airline to Legend. Assign flights.dep_delay to Values. (See visualization_settings.png)

exception.txt

Cannot download connector from linked page

The link in the homepage to download the connector (https://mariadb.com/downloads/#connectors-connectors_dataanalysis) does not seem to work, it brings you to the page to download the various connectors but there is no option for "data analysis" nor "power bi" or similar.

How can one download the connector, given that it seems to be not available with "plain" PowerBI Desktop?

Invalid Connection Credentials

We are currently using MariaDB driver 3.01.15.00 in our systems and while refreshing our PowerBI reports, we sometimes get invalid connection credentials error in PowerBI. On reaching to the Microsoft support team, they suggested to check with the MariaDB support team for the latest driver.

Could you please help in this matter ?

Help with MariaDB Direct Query Adapter for Microsoft Power BI

I have tried the MariaDB connector on my pc and it works great.
Can I please get directions on how to install the adapter on my OnPremise Gateway in order to build reports on my PowerBI desktop and publish them to the gateway?

I installed the connection to my MySQL db on the Gateway but I don't know how to build reports (on PBI desktop) using that connection. Any help is greatly appreciated.

Thank you,
Scott Williams

Query contains unsupported function

Today (07-dec-2022) I can no longer update the dataset automatically. The message appears stating that the data source does not support the update.

DataType Issues

Hello all,

I recently started to use mariadb columnstore in combination with powerbi. I am a bit new with both so i just hope i am doing something wrong here and the issue could be easily solved.

I am using powerbi with mariadb in directquery mode.

Problem:
Int(11) is not seen as an Integer by powerbi, therefor all int(11) will be casted to integer in the query
Date is not seen as a DateTime by powerbi, therefor all dates will be casted to datetime
Here i asume the full table will be copied to to a TMP table making the queries heavier and slower.

Quick fix:
Changed my int(11) to a double
Change my date to a datetime.

My original date dimension:

CREATE TABLE dim_date (
id int,
datedate Date,
datetime datetime,
day Integer,
day_name varchar(15),
month Integer,
month_name varchar(15),
year Integer,
date varchar(10),
week_number Integer,
quarter Integer,
quarter_name varchar(2),
year_month varchar(7),
year_quarter varchar(7),
is_weekday BOOLEAN,
is_weekend BOOLEAN
) ENGINE = ColumnStore;

Problem here: Integer becomes Int(11) in mariadb

==========================

My original fact:

use warehouse;
Drop Table fact ;
CREATE TABLE fact (
//removed
amount double,
dim_date int,
dim_time int
//removed
)ENGINE=ColumnStore ;

================

When i inspected the query's in mariadb i noticed the following:

where ((cast('ITBL'.'datedate' as DATETIME) in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) or (cast('ITBL'.'datedate' as DATETIME) in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) and 'OTBL'.'status' = ?

AND

cast('day' as INTEGER) as 'C1', 'day_name', cast('month' as INTEGER) as 'C2',
OR
cast('day' as DOUBLE) as 'C1', 'day_name', cast('month' as DOUBLE) as 'C2',

Expected issue:
I think somewhere the data type int(11) is not seen as a synonym for INTEGER.

Write Queries Directly

Hello!

Does this connector allows to write raw queries? I can't figure how to do it.

Thanks!

Connection to large MariaDB hangs on Foreign Key Detection

When running on a database with few tables, connecting powerBI to MariaDB works like a charm. But when the number of tables grows, PowerBI becomes unresponsive, and can't open the smallest of tables. The problem is the way PowerBI checks for foreign keys between tables. When loading a preview of a table, PowerBI starts the query below. If you look at this query, you will see that it looks for (possibly missing) matches between all tables in the server, the table itself included. Even if the A.REFERENCED_% fields are empty (= NULL), the query looks for any possible matches to other tables in the server, causing an N^2 combination to look through. Similar for the REFERENTIAL_CONSTRAINTS. As you see, this quickly becomes a huge resultset to scan, even if the referenced A.column_names are empty.
This check is performed on the tables your user have access to, so limiting access can reduce the problem. But still this is a rather unnecessary check, where it checks the relations between hundreds of tables, even if you only ask for data in 1 table. The query seems to be the same when it enters the MariaDB, regardless if PowerBI has connected via ODBC or using the connector provided by MariaDB.
Are anyone in here familiar with this problem, and more importantly, does anyone have a workaround that is better than splitting our databases over multiple servers and/or limiting user access?

I see that other ODBC connectors such as cData have an attribute "EnableForeignKeyDetection" which is by default set to False, this would probably solve this issue.
https://cdn.cdata.com/help/SRG/powerbi/RSBHelpinfo_p_EnableForeignKeyDetection.htm

Enclosed is the code that enters our MariaDB:
SELECT A.REFERENCED_TABLE_SCHEMA PKTABLE_CAT, NULL PKTABLE_SCHEM, A.REFERENCED_TABLE_NAME PKTABLE_NAME, A.REFERENCED_COLUMN_NAME PKCOLUMN_NAME, A.TABLE_SCHEMA FKTABLE_CAT, NULL FKTABLE_SCHEM, A.TABLE_NAME FKTABLE_NAME, A.COLUMN_NAME FKCOLUMN_NAME, A.POSITION_IN_UNIQUE_CONSTRAINT KEY_SEQ, CASE update_rule WHEN 'RESTRICT' THEN 1 WHEN 'NO ACTION' THEN 3 WHEN 'CASCADE' THEN 0 WHEN 'SET NULL' THEN 2 WHEN 'SET DEFAULT' THEN 4 END UPDATE_RULE, CASE DELETE_RULE WHEN 'RESTRICT' THEN 1 WHEN 'NO ACTION' THEN 3 WHEN 'CASCADE' THEN 0 WHEN 'SET NULL' THEN 2 WHEN 'SET DEFAULT' THEN 4 END DELETE_RULE, A.CONSTRAINT_NAME FK_NAME, 'PRIMARY' PK_NAME, 7 AS DEFERRABILITY FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE A JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE B ON **(B.TABLE_SCHEMA = A.REFERENCED_TABLE_SCHEMA AND B.TABLE_NAME = A.REFERENCED_TABLE_NAME AND B.COLUMN_NAME = A.REFERENCED_COLUMN_NAME)** JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS RC ON **(RC.CONSTRAINT_NAME = A.CONSTRAINT_NAME AND RC.TABLE_NAME = A.TABLE_NAME AND RC.CONSTRAINT_SCHEMA = A.TABLE_SCHEMA)** WHERE B.CONSTRAINT_NAME= 'PRIMARY' AND A.TABLE_SCHEMA = BINARY 'SOMEDATABASE' AND A.TABLE_NAME = BINARY 'sometable' ORDER BY FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, KEY_SEQ, PKTABLE_NAME;

Cannot change data type in Power Query

Changing data type throws error. Column is calculated and only contains 0 and 1.

Is there a way to disable query folding?

MariaDB connection doesn't allow for full Port Name

I am connected to the MySQL db via Oracle SQL Developer. The connection uses Port: 3306/?serverTimezone=PST#/billmax
In the Maria Connection settings, I only am able to put in 3306.
I think this is causing a connection issue when I publish the report to the PowerBI gateway.

Also, the MariaDB getting started page says:
You are now connected to your remote MariaDB database and can choose your data source and run queries and create visuals with Microsoft Power BI.
When I add a table using the data source, it seems that the report becomes InMemory instead of Direct Query. Can you please direct me to how I add a query on my db in PBI?

All help is much appreciated!
This tool will really help my company so I'm hopeful on getting it to work.
Scott Williams