When you use the Power BI Desktop connector for Business Central:
you will see all your environments (production, sandboxes,…):
And if you try this in the latest version, with the new look & feel, you will see something like this:
— Steven Renders (@srenders) November 15, 2019
How cool is that!
Thanks Microsoft for implementing this idea: