The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello everyone,
is it possible in Power BI Report Server to change a parameter?
If not is it possible in Power Query to realize if Power BI Desktop is in use or Power BI Report Server?
I have to change the query depending on the used platform (Desktop or Report Server).
Thank you and best regards
@selimovd wrote:is it possible in Power BI Report Server to change a parameter?
I assume that you are talking about a Power Query parameter - in which case the answer is no you cannot do this. You can only change those parameters from inside Power BI Desktop. The only thing you can configure from Power BI Report Server are the connection details for certain types of connections.
If not is it possible in Power Query to realize if Power BI Desktop is in use or Power BI Report Server?
No, sorry this is not possible either. You could maybe post this as a suggestion at https://ideas.powerbi.com
I can't even think of a good workaround as you cannot read environment variables either.
Is this still not supported (since you last commented)?
DAX, so Power BI desktop currently does not provides report context information such as report name, current page name etc.
Power BI Report Builder does some of them like;
=Globals!ReportServerUrl
=Globals!ReportName
=Globals!ReportFolder
=Globals!PageName
If my post solved your problem, mark my post as a solution to help others to quickly find it and also please give it a 👍