Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
pavel_severov
Advocate I
Advocate I

Check current environment: "desktop" or "service"

Hello! Is there way to check current environment in Power Query?
I.e. - is it running on "desktop" or "service"?

The reason I'm asking - I want my report to automatically use different data sources, depending: is it working on my PC? or on the server?.

 

5 REPLIES 5
aalev
Frequent Visitor

hello pavel_severov, I have the same need, did you sort it out ?

 

I tried with parameters, but it's not satisfying:

- My M code uses env paramter to select right sources (if env = ...)

- My pbix has env = A

- I publish the pbix, it overwrites the PBI service parameter & triggers a refresh

- As soon as the refresh is finished, I can modify the PBI service parameter to env = B

 

I'm looking for a way without having to update PBI service parameter each time I publish.

Any idea ?

 

Alban

 

Hi aalev,

Unfortunately there is no way to get any environment data from Power BI scripts.
At least I don't know anything about it. I would be happy to be wrong.

Ok, thanks @pavel_severov , I submited a feature request here: 

Power query environment variable to distinguish Power BI Desktop from Power BI Service

Please support with your votes  !

Alban

 

v-juanli-msft
Community Support
Community Support

 

ok

 

Best Regards

Maggie

 

Greg_Deckler
Super User
Super User

I am not aware of a way to do that. I suppose you could set a query parameter just before you publish it?


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Top Solution Authors
Top Kudoed Authors