Parsing json data within csv

[alexha73]

I have recreated a python scraping script which as a result provides the following result:

Temporada,Data,Jornada,Equip Local,Equip Visitant,Equip 1,Equip 2,Estadístiques
TEMPORADA 2022-2023,"Data: 24-09-2022, 12:30h",Jornada 1,"BARCELONA, F.C. A","DAMM, C.F. A","{'Titulars': Jugador
1 SAUCEDO AVAROMA, JORDI
2 VICTOR DELGADO, GUILLEM
3 NATALI , ANDREA
4 CUENCA CEJUDO, ANDRES
5 TORRENTS SALVAT, JOFRE
6 BERNAL CASAS, MARC
7 CARLOS
8 AVILA MARMOL, DANIEL
9 HERNANDEZ TORRES, JUAN
10 JUNYENT CASANOVA, QUIM
11 KLUIVERT , SHANE PATRICK, 'Suplents': Jugador
12 FARRÉ MIRÓ, LANDRY CÉPHAS
13 BONFILL COLL, MAX
14 FERNANDEZ CASINO, GUILLERMO
15 SACA , LEONARD
16 ESPART FONT, XAVI
17 SYLLA DIALLO, NOUHOUN
18 GISTAU FERREÑO, ÓSCAR, 'Equip Tècnic': Equip Tècnic
0 CARRASCO PEREA, IVAN
1 SUAREZ GALVAN, ANTONIO
2 BLANCO MORENO, ARNAU
3 PONS MARTINEZ, SIMON
4 REINA VILLATORO, SAUL
5 RIVAS GONZALEZ, PABLO, 'Targetes': Jugador Minut Targeta
TORRENTS SALVAT, JOFRE NaN 36' groga}","{'Titulars': Jugador
1 ESTEVEZ RUBIO, MANEL
2 BORREGO CRUZADO, DAVID
3 RAFÚS AULET, JORDI
4 MEDINA LOPEZ, JOAN
5 ANGLADA GARCIA MIRANDA, GUILLEM
6 RICO CORDERO, POL
7 VILLARRASO SAMPER, NIL
8 ISERN GENE, ORIOL
9 GONZALEZ YANES, ALEX
10 RUBIRA COLAS, ADRIA
11 SOLA BURGOS, IAN, 'Suplents': Jugador
12 ROUCO BARRENA, HUGO
13 LOPEZ PASCUAL, PAU
14 LARGO SILVESTRE, PAU
15 FERNANDEZ MARTINEZ, ELLIOT
16 MORALES GOMEZ, CRISTOBAL
17 DEL MORAL RUZAFA, IKER
18 RIOS PEREZ, JOSE LUIS, 'Equip Tècnic': Equip Tècnic
0 MENGUAL GALINDO, ANTONIO
1 FALCES VIÑOLA, IGNACIO
2 MONZONÍS ZORRILLA, CARLOS
3 MORALES SUBIRACHS, GENÍS, 'Targetes': Jugador Minut Targeta
RUBIRA COLAS, ADRIA NaN 17' groga
MORALES GOMEZ, CRISTOBAL NaN 79' groga}","{'Àrbitres': {'Àrbitres': Àrbitre 1 Àrbitre 2 Àrbitre 3
0 GARCIA MUÑOZ, ORIOL ABELLO LILLO, SERGI LOPEZ RODRIGUEZ, FELIPE}, 'Gols': {'Gols': Player Name Tipus Timestamp
0 CARLOS Normal 30'
1 KLUIVERT , SHANE PATRICK Normal 34'
2 CUENCA CEJUDO, ANDRES Propia 35'
3 KLUIVERT , SHANE PATRICK Normal 44'
4 HERNANDEZ TORRES, JUAN Normal 54'
5 BERNAL CASAS, MARC Normal 79'}, 'Estadi': {'Estadi': Estadi None
0 None av. del Sol, s/n, Sant Joan Despí}, 'Comparativa': {}}"

This is how I see it PowerBI:

I would like to know what needs to be done to correctly extract all the data, so I can build some data for all the game fixtures of a season. 

Thanks in advance,

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).  Also, add your source file in Excel format.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.