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?
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?
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.