Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |