Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Write to mysql the selected row from data table

Hi, I created a PowerBI report. Requirement is to write to mysql the selected row from data table in dashboard.

I created a measure for tapping into the selection. Now I want to append this selected value, to a webURL (which is the action URL of button), dynamically. The webURL is of an API that recieves the parameter and posts it into database. I am unable to append the selected value to my API url from PowerBI. 

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    No need for a measure.  Use a PowerApps , R or Python visual to grab the contents of your current filter context and then post to the database. Be aware that there is no built-in data write-back capability in Power BI. You're on your own.