Forum Discussion

Suprith's avatar
Suprith
Frequent Visitor
8 years ago
Solved

Report Server Power BI

Hello Team, 

 

As we build rdl reports using Expression-based Connection Strings, can we define Parameters in PBIX (the reports we have deployed in SSRS ) which prompts for Parameters when report url is opened on machine where Power BI Desktop not installed.

 

Eg : Basic report which asks for SQL Server name (Dynamic Value) and list all the processes running  in it. 

Thanks in advance. 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Suprith,

     

    We could add Query Parameter in Power BI report to dynamically select data source. But this parameter  is not supported on Report Server. After publishing PBI report to report server, there is no parameter prompt when we open the report. So, I'm afraid your requirement cannot be achieved now.

     

    Best regards,

    Yuliana Gu

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi Suprith,

     

    We could add Query Parameter in Power BI report to dynamically select data source. But this parameter  is not supported on Report Server. After publishing PBI report to report server, there is no parameter prompt when we open the report. So, I'm afraid your requirement cannot be achieved now.

     

    Best regards,

    Yuliana Gu

    • Suprith's avatar
      Suprith
      Frequent Visitor
      6 years ago

      @v-yulgu-msft 

       

      Hope you are doing well, is there any enahcnement to Power BI Report Server, since we spoke last time.