Hello all,
I just removed all connectors and reinstalled them, removed custom connectors from the Power BI Desktop folder as I saw mentioned in another thread, also made sure to uninstall the previous Power BI v2 connector via the Speckle Manager, and I finally managed to connect to my projects.
Be aware that there are some small changes in the query, some of the columns are renamed (Object ID became Object IDs, speckle_type became Speckle Type) some do not exist anymore such as the Model URL and the URL Type.