Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi there,
I wish to connect to a SendGrid content pack and also merge this with data from SQL Server.
When I use PowerBI online (I cannot connect to SendGrid using PowerBI Desktop), I can only connect to SendGrid but cannot connect to another SQL Server repository at the same time - is this correct?
If the above isn't true, feel free to correct me.
Thanks in advance,
S
In addition to @Seth_C_Bauer, 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, I think the "get data"->"other"->"web" can help to get data from Power BI desktop.
Eric - excellent suggestion, but unless I am doing something wrong, that API connected through the method you specify in PowerBI desktop doesn't open up the data source properly. Can you help? You are getting very close....
Thanks.
@SachinC wrote:
Eric - excellent suggestion, but unless I am doing something wrong, that API connected through the method you specify in PowerBI desktop doesn't open up the data source properly. Can you help? You are getting very close....
Thanks.
What do you mean "doesn't open up the data source properly"? What is wrong in your case?
I don't exactly know the SendGrid APIs, regarding the so called "data source", I think you would put more effort on researching the APIs.
Hi,
Using the API web call string, it authenticates, however I only get Kind, Name and Text (no idea what this means). I was looking for the usual fields - i.e. #Sent, #Bounced, #Spam etc...
That's why this has thrown me!
Regards,
S
@SachinC wrote:
Hi,
Using the API web call string, it authenticates, however I only get Kind, Name and Text (no idea what this means). I was looking for the usual fields - i.e. #Sent, #Bounced, #Spam etc...
That's why this has thrown me!
Regards,
S
So the web source already works.
You shall dig into the APIs to find out the ones that would return required data in your case. Regarding any question on SendGrid APIs, SendGridis official site is a proper place and you will get better response there.
Hi,
SendGrid have confirmed the API URL only contains a small element of what I need. They will confer internally with their developers.
I am now snookered on what to do next?
To recap, I want to mashup SendGrid & MS SQL data sources in one report / dashboard using PowerBI. To go a level further, I may want to introduce Google Analytics into this, but for the moment the core focus is on SendGrid and SQL.
Thoughts anyone?
Thanks,
S
@SachinC wrote:
Hi,
SendGrid have confirmed the API URL only contains a small element of what I need. They will confer internally with their developers.
I am now snookered on what to do next?
To recap, I want to mashup SendGrid & MS SQL data sources in one report / dashboard using PowerBI. To go a level further, I may want to introduce Google Analytics into this, but for the moment the core focus is on SendGrid and SQL.
Thoughts anyone?
Thanks,
S
I think you're pending on SendGrid, SQL Server is always ready for Power BI. Regarding anything next to do, maybe ask the SendGrid for any other way to get the usual fields - i.e. #Sent, #Bounced, #Spam etc. Does the content pack in Power BI service contains the all the fields required? If yes, expect the API way, there shall be some other programmable approach.
@SachinC In order to mash up data from two sources, you need to get that data into Power BI Desktop. In the case of SendGrid, there currently isn't an out fo the box connector in the Desktop. So, you would need to explore other connection options, such as Odata to connect to the SendGrid data, and also pull in your SQL data if you needed to combine the two data sets.
The Service won't allow you to do this (as you assume).
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |