Welcome to the community, @Karolina! Have you gone through our support article Pulling Data Into Excel Power Query? If no, maybe it would be helpful for you to understand what is not working.
Clue: Maybe you have not made your data public? Try making it public. That should solve your issue.
