Need help on filtering with sending domain on send grid

[faith24]

Im using Power BI to connect with my sendgrid dashboard. My sendgrid account has many senders from different domain name. I would like to filter out 1 of them to get the sending report of emails sent, bounce, opened and etc.

Please advice how I can do that.

And if there are help posts on this in greater details.

[v-ljerr-msft]

Hi @faith24,

Are you connecting to your SendGrid using SendGrid content pack for Power BI? If so, I don't think it is possible to do it currently. Because the domain name is not included in the dataset of the content pack. 

In this scenario, I would suggest you to submit your requirements on Power BI Ideas to request the dataset include more information you need.

In addition, SendGrid has provided variable APIs to get data, check Using the Web API. A sample in that link is like

https://api.sendgrid.com/api/blocks.get.json?api_user=your_sendgrid_username&api_key=your_sendgrid_password

In this case, you should be able to use "get data"->"other"->"web" to get the data you need from Power BI desktop. However, by this way, you may need to re-build the whole report.

Regards