Student Cribs Graduate Systems Support Analyst interview questions

Firstly you had to do an excel test on test dome which was relatively easy. Then I had my first round interview with a member of staff there, it went really well and the guy was great to talk to. After that I was invited to be interviewed at their office where I had an interview with three people. After this long process, they sent me an SQL & Power BI test to do. After a week of focusing hard on these tests, I managed to pass them and do quite well. Then I was told I needed to come in AGAIN, to have an interview with the team as the role had 'changed'. I came in again into their office, their offices are very nice, and I had another round of interviews that I believe went very well too. After another week of waiting, I get called and I am told that the role had not been 'authorised' by their shareholders. So I had just gone through almost 2 months of interview stages, three meetings, 3 tests for a role that had not even been approved?