Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |