Forum Discussion
Problem pulling data out of MySQL in Power Query
Hey there. I've been trying to pull data out of a MySQL server all day long but did not manage to. What I got so far is a two-column wide table that contains the ticket Id and the values of the t...
Anonymous , You can bring in Json in Power Bi and can split that column here in power bi
How to import JSON Data: https://youtu.be/MPYfEetvFH4
In select please check the exact function you want to use, in case you are using custom SQL
Thanks for your response, amitchandak .
I watched your video but I don't think it fits in my problem. Basically in my case I pull the data from a MySQL server, and from there each row has a JSON alike format (in each row there's a string from which I can extract the data from).
However, it's also possible that I did not understand what you meant in your message. In what part should I select the MySQL to bring these JSON files?
Once again, thanks for your response.