open a dynamic php website with the actual filter in the link

[Anonymous]

Our idea is to have a write back funtion in the PowerBi app.

We already run a mySQL server with some fields where information can entered and stored via a PHP website.

We struggle now to open (on click) this php website in the report view in the app.
The actual filter will contain the unique ID of the data item.

Background:

We have a table with old stock items (plant, material and batch as unique combination).

The User can drill via filters / visuals to their responsible old stock item and should be able to enter what and until when they will clear this old stock into the SQL table.

Any ideas how to enable this transfer of the filtered element to an opening website?

Best regards

[lbendlin]

"should be able to enter what and until when they will clear this old stock"

How?  using which visual?  What-If parameters?

The only semi-supported write-back option at the moment is the PowerApps visual but it provides for a sub-optimal user experience.  

You could explore SVG trickery, or the HTML5 visual, or R/Python visuals etc.

[Anonymous · Accepted solution]

 We got around by creating a button open a php website referring to an SQL database.

By this "work around" we do not open the website inside Powerbi but outside.

As the SQL server is refreshed in PowerBi regularly we closed the loop and the entered information are shown in the report itself as well.

In questioning how this was done, please email me.

BR