08-26-2021 07:23 AM - last edited 09-27-2021 06:22 AM
I have created Chess PGN Player in Power BI. I have not used Python, R or any API. This is purely based on Power Query.
The PGN File is a simple txt file having Event details and the Chess Notations.
Data Source:- FIDE (International Chess Federation)
Separting Event Details and Chess Game Sequence
Reading Game Sequence (Move by Move)
Reading Moves (Position, Player)
This also included reading Right/Left castling.
Generating Board Positions respective to the move sequence (THIS WAS THE BIGGEST CHALLENGE)
This includes finding the previous position of the marble and removing it from Previous Board Postion and Preparing the Current Board Position
Displaying the chess positions with actual pieces as per the move sequence