Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Parameters from external app

Hello,

I would like to know if there is any way to open Power BI Desktop through an external app passing a parameter.
I mean, I want to open PBID using a parameter to display specific data linked to the given parameter.

thanks,

regards

Need Help
Tips and Tricks

2 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    I am not aware that you can open PBI with an external app; however, you could store your parameter value(s) in an Excel or txt file that your external app creates, and then have PBI Service refresh using that file and the extracted text value(s) to use in other queries.

     

    Also, if you can trigger a flow from your external app (e.g., send an email when it runs), you can then refresh your power bi dataset with the same flow.

     

    Regards,

    Pat

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks Pat, 

      Actually, using a batch command is ok to open a pbix file. I would need to pass a parameter to this batch in order to filter data using this parameter(in a sql query)

       

      Thanks,

       

      Xavier