Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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?.
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:
Please support with your votes !
Alban
ok
Best Regards
Maggie