Exactly as GabriPowerBI explains it.
The connect to PowerBI functionality has been part of my Excel for atleast half a year now and I haven't had the issue before. I'm guessing the error is part of the latest build as it seems to have appeared after a forced software update from our IT-department.
Usually I would be able to connect to all my PowerBI datasets as made available in the online portal. I can then use these datasets as I would use a SSAS cube. However as explained through the inital post I can no longer access the datasets, unless I'm using a workaround.
I'm using the following version
Microsoft® Excel® til Microsoft 365 MSO (Version 2303 Build 16.0.16227.20202) 64-bit
EDIT: So I just tried updating my Excel and it seems there is another issue. When going to account and looking for my version number I get one version:
However, when I actually press the button I get another version
I believe my initial version might have been the same as Gabris.
Updating Excel did not fix the issue.
Best regards
Helm