Forum Discussion

epang's avatar
epang
Advocate I
2 years ago
Solved

Dashboard 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...
Need Help
Tips and Tricks
  • nandic's avatar
    nandic
    2 years ago

    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

nandic's avatar
nandic
Resident Rockstar
2 years ago

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

epang's avatar
epang
Advocate I
2 years ago

Hi,

 

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"

        }

    }

}