Forum Discussion
Subscribe report email
- 1 year ago
Hi migueldfr
When you try to subscribe Power BI reports to users using their [user][companyname]@onmicrosoft.com
accounts, you may find that these emails don’t actually deliver because these accounts often don’t have real mailboxes linked—they are just Azure AD identities used for authentication within Microsoft services, not actual email inboxes. This is why the users with Gmail-based company emails don’t receive the subscription emails, except maybe the administrator who has a mailbox linked to the onmicrosoft.com domain.
Since your users primarily use Gmail for their company emails, the Power BI subscription emails need to be sent to their actual Gmail addresses rather than their Azure AD (onmicrosoft.com) IDs. Unfortunately, Power BI subscription emails do not automatically translate or forward to alternative email addresses unless those emails are set as their primary email in Azure AD or configured as aliases that route mail to their real inbox.
To resolve this:
-
Verify User Email Addresses in Azure AD: Ensure that each user’s primary email address (User Principal Name or UPN) in Azure AD is set to their Gmail-based company email, or at least that their Gmail address is configured as a proxy email address (alias) in their Azure AD user object.
-
Update UPN or Email Aliases: Work with your Active Directory and Azure AD admin to update users’ UPNs or add Gmail addresses as aliases. This allows Power BI to send subscription emails to the actual email address users check daily.
-
Use Distribution Lists or Security Groups with Correct Emails: If you want to subscribe multiple users at once, create an email-enabled distribution list or security group in Exchange Online or Google Workspace that includes their Gmail addresses. Then subscribe the report to that group email.
-
Check Email Flow and Spam: Ensure that your organization’s email system (Google Workspace) isn’t blocking or filtering out Power BI subscription emails. Adding Power BI service addresses to safe senders helps.
-
Test with Direct Gmail Addresses: When setting up the subscription, try adding users’ actual Gmail addresses instead of the onmicrosoft.com ones to confirm delivery.
Power BI subscriptions send emails to the email address recognized by Azure AD as the user’s mailbox, so you must make sure that this matches their real inbox address. Adjusting the user email settings in Azure AD or using distribution groups with the correct Gmail addresses will help ensure the subscription emails reach the intended recipients.
-
Hello
Yes, I got this screen and now is still not working
Also, maybe the people who hope a subscription need to be member or collaborator of the workspace where the app comes , could be ?
Thanks
No they dont need to be a part of your workspace but they should be a part of your organization Entra atleast as a exteranl B2B guest user.
https://learn.microsoft.com/en-us/entra/external-id/what-is-b2b
If you do not want to add them as guest users in your organization AD/Entra then you need to implement a workaround like using power automate to send subscriptions as an email.
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|
- migueldfr1 year ago
Helper IV
Ok , got it.
I needed to change the capital letter of the email, because was wrong.
In the other hand, I would like to have a flow into power automate, which take a screen of a report and sent out to all user within organization splitting by departament.
But the account whom belhalf the sender is [user][companyname]@onmicrosoft.com and this does not have as mail box.
So maybe I have to change the main email to a coporative one user@[company].esCould be ?
Thanks- tharunkumarRTK1 year ago
Super User
If you want to send emails with an email which is something like a corporate mail then you should opt for a shared mail box. But it will have mail box.
While you are configuring your power automate fow you need to use "Send email from a shared mail box action"
Also, if you want to send the report image as a attachment and report as a pdf from power automate, You can follow this approach
1. Create a normal subscription in power bi and save the pdf in a sharepoint folder
2. create a power automate flow which will take the pdf from the shared folder and sends it as an attachment. (Use shared mailbox instead of instead of your individual email as sender)
Hope this anwers your question.
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
- migueldfr1 year ago
Helper IV
Hi everyone,
I have a question regarding Power BI subscriptions.I'm trying to send a subscription to several users. The first four have "Fabric Trial Free" accounts, while the last one (user H) doesn't have any subscription tied to a Premium capacity.
When I try to subscribe this last user to a report page, I get the following message:
"Free users or groups can only subscribe to reports backed by Premium capacity. Learn more."
Could this be the reason why the message is not being delivered to that user's mailbox?
Any guidance would be greatly appreciated.