Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.