Power Platform Community Forum Thread Details

Hi, I am new to Power Automate. I want to run a SQL Agent Job from an on-premise SQL server to load data into a data warehouse. After this task is completed, I want to refresh the dataset on the Power BI service. Then, I would like to send an email to a group of people to notify them that the Power BI reports are ready for review.

I installed a data gateway and created a connection to my database on the Power Automate portal. I also created a stored procedure to run the SQL Agent Job and set up the flow with a manual trigger. However, I am encountering an error when I try to create an SQL action to execute the stored procedure. Could you please help me resolve it?
Error Details: The dynamic operation request to API 'sql' operation 'GetProcedure_V2' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response:

{
 "status": 400,
 "message": "The key didn't match any rows in the table. Inner exception: The key didn't match any rows in the table.",
 "clientRequestId": "4e55b264-478a-4810-b5e7-70eb0fc3110f",
 "error": {
 "message": "The key didn't match any rows in the table. Inner exception: The key didn't match any rows in the table."
 },
 "source": "sql-usgv.azconn-gcc-usgv-001.p.azurewebsites.us"
}

Could you please help me understand how to refresh a dataset on the Power BI service?
Could you also advise on how to send an email once the above two steps are completed?

Thank you for your assistance!

Ravi Potturi

Categories:

General topics