cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bfaivre Frequent Visitor
Frequent Visitor

Bring MySQL JSON data type / query into Power BI

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:

 

2016-10-20_21-29-50.jpg

 

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

 

Thanks,

 

Brian

1 REPLY 1
v-micsh-msft New Contributor
New Contributor

Re: Bring MySQL JSON data type / query into Power BI

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

 

 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 128 members 1,727 guests
Please welcome our newest community members: