Forum Discussion
Hank_
5 years agoHelper I
Duplication of values/rows when parsing a JSON
Hello everyboy, I really hope you can help with this issue that's giving me headache! I'm importing from MySQL several tables with 3 columns: - id - json - timestamp I transform the JSO...
Hank_
4 years agoHelper I
Sorry for not replying, but I've been very busy and when possible we tried to update PBI, .net Framework and other stuff with the IT. I've exported manually the json files from MySQL and imported them as xlsx files and everything was fine.
Finally we understood what was wrong: it was the connector to MySQL, which was running on my local PC thanks to XAMPP 7.4.8.
I got installed from my IT MariaDB connector 3.1.13 and now I can import without those duplication of records that overwrites other records! I would be happy to report this to Microsoft because we are sure this is a kind of bug.
- jennratten4 years agoSuper User
Great news.