Check current environment: "desktop" or "service"

[pavel_severov]

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?.

[aalev]

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

[pavel_severov]

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.

[aalev]

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]

ok

Best Regards

Maggie

[Greg_Deckler]

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