Forum Discussion
Power BI To Automatically Send Alerts if Conditions Are Met
In fact the alert is only for you, you can share the repport for people of your organisation, but you can only have the alert by mail for you. You could perhaps use a low code solution to manage the mail to create automaticaly an alert to someone else when you receive the alert on your own mail. It could be possible with the tools Make or Zapier.
If someone else have received the repport that you've shared to him, he could create his own alert by data activator very quickly.
You could insert the request in Power BI in excel and if you have reached a level send an email with this code in Excel : (you should keep Excel open on the server.)
Sub SendEmail()
Dim OutlookApp As Object
Dim OutlookMail As Object
Dim AdresseDestinataire As String
Dim SujetEmail As String
Dim CorpsEmail As String
Dim FichierJoint As String
'Var for the mail
MailAdress = "[email protected]"
SubjetEmail = "Sujet de l'email"
BodyEmail = ""
JoinFile = "C:\Chemin\Vers\Fichier\Joint.xlsx" ' Chemin complet vers le fichier joint (optionnel)
' Start Outlook
On Error Resume Next
Set OutlookApp = GetObject(Class:="Outlook.Application")
If OutlookApp Is Nothing Then
Set OutlookApp = CreateObject(Class:="Outlook.Application")
End If
On Error GoTo 0
' Create a new mail
Set OutlookMail = OutlookApp.CreateItem(0)
With OutlookMail
.To = AdresseDestinataire
.Subject = SujetEmail
.Body = CorpsEmail
If FichierJoint <> "" Then
.Attachments.Add FichierJoint
End If
.Send
End With
' Libérer les objets
Set OutlookMail = Nothing
Set OutlookApp = Nothing
End Sub
Hi
I'm using a paid power bi if I publish it will it not be available to the public especially if they have the link?