Bring MySQL JSON data type / query into Power BI

[bfaivre]

Hello,

I’m attempting bring data from a MySQL query into Power BI. The table has two columns “TagId” data type is INT and Value data type is JSON. The path I am wanting to return from Value is “pv”.

Here is the query that executes fine:

SELECT TagId, JSON_EXTRACT(Value, "$.pv") pv FROM TagValue;

When I put this query in the “SQL statement” in “Advanced options” of my “Get Data” I get the following error message:

Anyone have experience or recommendations on how I can accomplish this?

Thanks,

Brian

[v-micsh-msft]

Hi bfaivre,

I am not very familiar with MySQL, I suggest that we take a look at the general query log in MySQL, see if the query language putted into Power BI Desktop would get the proper result in MySQL.

Also, please enable Power BI Desktop Tracing:

File -> Options & Settings -> Options->Global->Diagnostics, check the tracing

By the way, would it be available to select the table item through the Table List?

Regards