Forum Discussion
Advocate IDashboard notification automation
Hi all,
I am very new to this Power BI publishing. Recently we have published a dashboard online with a list of over 100 users.
I would like to know is there anyway to notify the users when the dataset is refreshed and published. I have heard that you can do it through Power Automate.
PLease advise how to do the followings:
1) Notify all users through email
2) Notify a subset of users through email
Many thanks
Edmund
epang you can use Power Automate to complete whole process:
1) schedule Power BI dataset refresh
2) send email after refresh has been completed
Link: https://www.mssqltips.com/sqlservertip/6885/notify-users-of-power-bi-dataset-changes/
If you don't want to use Power Automate, you can add visual on dummy report with latest date time information.
Every time dataset is refreshed, this value will be different.
But make sure to format it as a number and put into card visual (otherwise will not work, as dashboard alert request this data type).
Then when on Power BI Service, pin this visual to a dashboard. Then on this tile on dashboard create alert and set to send alert when condition > 0.
Everytime dataset has been refreshed, you will get notified via email.
Set forwarding rule to specific user group.
Cheers,
Nemanja Andic
4 Replies
- nandic
Resident Rockstar
epang you can use Power Automate to complete whole process:
1) schedule Power BI dataset refresh
2) send email after refresh has been completed
Link: https://www.mssqltips.com/sqlservertip/6885/notify-users-of-power-bi-dataset-changes/
If you don't want to use Power Automate, you can add visual on dummy report with latest date time information.
Every time dataset is refreshed, this value will be different.
But make sure to format it as a number and put into card visual (otherwise will not work, as dashboard alert request this data type).
Then when on Power BI Service, pin this visual to a dashboard. Then on this tile on dashboard create alert and set to send alert when condition > 0.
Everytime dataset has been refreshed, you will get notified via email.
Set forwarding rule to specific user group.
Cheers,
Nemanja Andic
epangHi,
I have received an error when trying to run the task through power automate. Any clues???
{
"statusCode": 403,
"headers": {
"Cache-Control": "no-store, must-revalidate, no-cache",
"Pragma": "no-cache",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Frame-Options": "DENY",
"X-Content-Type-Options": "nosniff",
"RequestId": "4571fd35-7727-4c70-963b-d715740b98ff",
"Access-Control-Expose-Headers": "RequestId",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"Date": "Fri, 17 May 2024 05:39:18 GMT",
"Content-Length": "129",
"Content-Type": "application/json"
},
"body": {
"error": {
"code": "InvalidRequest",
"message": "Report requested for export is not on dedicated capacity"
}
}
}
Your solutions is great nandic
Hi, epang
Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster. Thank you very much for your kind cooperation!As nandic says, you can do this with Power Automate. In Power Automate triggers a refresh of the Power BI semantic model. When the refresh is complete, send an email. Or you can set a trigger in Power Automate to send an email when the Power BI semantic model changes. You can refer to the following official documentation:
Integrate Power BI data alerts with Power Automate - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- epang
I have received the following error when trying to run the power automate.
{
"statusCode": 403,
"headers": {
"Cache-Control": "no-store, must-revalidate, no-cache",
"Pragma": "no-cache",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Frame-Options": "DENY",
"X-Content-Type-Options": "nosniff",
"RequestId": "4571fd35-7727-4c70-963b-d715740b98ff",
"Access-Control-Expose-Headers": "RequestId",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"Date": "Fri, 17 May 2024 05:39:18 GMT",
"Content-Length": "129",
"Content-Type": "application/json"
},
"body": {
"error": {
"code": "InvalidRequest",
"message": "Report requested for export is not on dedicated capacity"
}
}
}
