Forum Discussion

Hank_'s avatar
Hank_
Icon for Helper I rankHelper I
5 years ago

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...
Need Help
Hank_'s avatar
Hank_
Icon for Helper I rankHelper I
4 years ago

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.

  • jennratten's avatar
    jennratten
    Icon for Super User rankSuper User
    4 years ago

    Great news.