Forum Discussion

selimovd's avatar
selimovd
Most Valuable Professional
6 years ago

Change parameter in Power BI Report Server

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

3 Replies

  • 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 👍


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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Is this still not supported (since you last commented)?